Skip to Content

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

Formula for dates


I have a report with a prompt where the user select a date. I want to display the prompt answer on the report however the answer includes the time. I am trying to apply the following formula to only display the dates

="Leaves from " + FormatDate(ToDate(UserResponse("Leaves from date:");"dd/MM/yyyy");"dd/MM/yyyy)

It says it is correct when validating it, however at the time of display it the report shows #ERROR.

Any ideas?



Former Member
Former Member replied

Hi Teresa,

Use Following:

="Leaves From " + FormatDate(ToDate(UserResponse("Leaves from date:");"");"dd/MM/yy")

Hope it helps!!


Sheetal Sharma

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