How to change Datetime to Date in report

[0swdas]

Hi Expert, I have a query regarding one formula,in database one column is date type like 26.07.2022 ,but when I am using that column in universe with date datatype it's showing like 26 july 2022 and after published universe it's showing to me 26.07.2022 00.00.00, so I use one formula still its not working showing error, I need as 26.07.2022 only could you please help me for this. img-20220806-wa0019.jpgimg-20220806-wa0020.jpg

I have uploaded the column data and my formula, please have a look and help.

Thanks,

Swastika

[bekart]

Here you will find the answer how to change it in SAP BO 4.3

[0swdas]

Hi kacper,

Thanks for sharing information, but i am not able to see the option of format display in my 4.3 ,could you please tell me how to enable that , I have right click on date column then I check but it's not visible to me. Pls find the screenshot.

Thanks,

Swastikaimg-20220823-wa0018.jpg