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
Please use below formula in WebI:
= FormatDate( [date object] ; "dd/MM/yyyy")
In your case, replace [date object] with your [CAL_Days] object.
Note: For additional information you may refer : How to use formulae to change date and time formats in WebIntelligence