on 01-06-2015 3:58 AM
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
Hi Teresa,
Use Following:
="Leaves From " + FormatDate(ToDate(UserResponse("Leaves from date:");"");"dd/MM/yy")
Hope it helps!!
Regards
Sheetal Sharma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.