Web I Audit report # ERROR

[Former Member]

Hi Gurus,

i am trying to customise an existing audit report in 3.1 environment.

j have created 2 variables

Start date: =FormatDate(ToDate(UserResponse("Start Date:");"");"MM/dd/yyyy")

End date: =FormatDate(ToDate(UserResponse("End Date:");"");"MM/dd/yyyy")

output: "Date range:  " + [Start date:] + "   to  "+ [End date:]

i am getting errror: #ERROR

Thank you for the help !!!

[amitrathi239 · Accepted solution]

HI.

Drag the startdate variable only  and if error is coming or not.

Add the same date format  which is coming from userresponse while using todate function.

Start date: =FormatDate(ToDate(UserResponse("Start Date:");"add date format");"MM/dd/yyyy")

Amit

[Former Member]

Break it down - What do you get for the UserResponse part?

That is the format that you need to put the second part of your ToDate in/
.

Si if you've got 16/11/2015, you'd need dd/MM/yyyy instead of MM/dd/yyyy