Skip to Content

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

Date format issue

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
replied

Hi

Can you please try below.

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question