Skip to Content
avatar image
Former Member

Formula for dates

Hi

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?

Thanks

Teresa

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 06, 2015 at 04:39 AM

    Hi Teresa,

    Use Following:

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

    Hope it helps!!

    Regards

    Sheetal Sharma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2015 at 05:12 AM

    Hi Sheetal

    Thanks so much for your answer, it worked 😊. I thought that in the ToDate() function you had to put the date format, that is what the help says. Is this an exception?

    Thanks

    Teresa

    Add comment
    10|10000 characters needed characters exceeded