Hi All,
We are facing some date issue.We are using the From and End date:
=FormatDate(ToDate(UserResponse(“1.Enter the Training Start Date (DD-Mon-YYYY):”);“d/M/yyyy hh:mm:ss a”);“dd-Mmm-yyyy”)
When we pass the date as 7/1/2015 it is working fine.When we give 8/14/2015 then will face Error.Please refer the screenshot.
But the error is appearing in Webi Rich cleint and in infoview it is working fine.
Regards
Rohit k
Rohit77 
(BOB member since 2005-10-24)
8/14/2015 doesnt match the format the prompt is expecting?
DD-Mon-YYYYMak 1 
(BOB member since 2005-01-06)
Hi Mark,
were i need to use =FormatDate(ToDate(UserResponse(“1.Enter the Training Start Date (DD-Mon-YYYY):”);“DD-Mon-YYYY hh:mm:ss a”);“DD-Mon-YYYY”)
I have changed the formula still i am getting the Error.
Please advise
Regards
Rohit k
Rohit77 (BOB member since 2005-10-24)
Changing the formula won’t help.
The prompt is expecting DD-Mon-YYYY for both date parameters.
8/14/2015 should be entered as 14/8/2015
Mak 1 (BOB member since 2005-01-06)
Hi Mark,
The date is appearing correctly till 12-Aug-2015.After 12th it is giving #Error.
Please advise the correct formula.
Regards
RK
Rohit77 (BOB member since 2005-10-24)
As I said you will get the error if you do not follow the DD-Mon-YYYY format in the prompt entry.
I cannot be more clear than that 
.
Mak 1 (BOB member since 2005-01-06)
Try 14/8/2015 and see what happens