Date format issue

[Former Member]

Hi,

The data coming through BEX for date is in the format dd:mm:yyyy hh:mm:ss am/pm. I would like to know how to format this in BO so that the date can be displayed as dd-mm-yyyy format only.

Regards,

G

[Former Member · Accepted solution]

HI Bhargav,

Please  create a variable with the the formula:

=FormatDate(ToDate([YOURDATE];"dd.MM.yyyy");"dd/mm/yyyy")

or FormatDate(yourdate();"dd/mm/yyyy")

Regards,

Ashvin

[arijit_das · Accepted solution]

mm is for minutes. Use MM instead

[former_member4998 · Accepted solution]

Hi

Can you please try below.

=FormatDate(ToDate(YOUR DARE OBJECT);"MM/dd/yyyy HH:mm:ss A");"dd'-'MM'-'yyyy")

[Former Member · Accepted solution]

Totally agree Thanks..

[Former Member · Accepted solution]

Thank you very much... Problem resolved

[former_member203850]

Hi Bhargav ,

Please go through the below link for complete list of date format :

And you can change the date format in universe as well :

Right click on object and select object format :

Regards,

Pranay

[Former Member]

Thank you for all ur replyy

[Former Member]

I am very new to SAP reporting tools and I have been trying to follow this date formatting, including the link you've given.  My data is coming into WebI as a number like the ending result of the link: 20141031.

I'd like to get it to a date so that I can filter the data like a date, as it is a date.  I'm sure there has to be a better way to do this that will give me a date in the end.  Can you help show me how to go the opposite direction with the format?

I've deconstructed the date and put it back together but there has to be an easier way.  The very end result of the reconstruction is showing on the table as #ERROR.

Thank you,

Jill

[arijit_das]

Use ToDate function to convert the number to a date:

=ToDate(FormatNumber([Your Number];"########");"yyyyMMdd")