Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

conversion of date format from 2015/09/24 00:00:00 to 24/09/2015 in webi report

Hi experts ,

conversion of date format from 2015/09/24 00:00:00 to  24/09/2015 .

the data is coming from bex query for object  [CAL_Days]  , Type : Date.

It may be simple .but please help me.. urgent .

iam attaching the sample data

Thanks...

Regards

Nikil

dates.PNG (2504 B)
Former Member
Former Member replied

Hi Nikil,

Please use below formula in WebI:

= FormatDate( [date object] ; "dd/MM/yyyy")


In your case, replace [date object] with your [CAL_Days] object.


Regards,

Aashutosh


Note: For additional information you may refer : How to use formulae to change date and time formats in WebIntelligence

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question