Getting #Error for variable

[brahmareddykatam]

Hi All,

We are getting #error for the below variable in the webi report.

=DaysBetween(ToDate(Substr(UserResponse ([Posting]; "P2 Postingdate Ende");1;10);"MM.dd.yyyy");[Enddate calc])/365

Please help us!

[krisa24]

What are the values in P2 Postingdate Ende? Could you send some examples?

Which date format does your instance use? Could you share how ToDate() value is displayed? There may be issue that date is not displayed as MM/dd/yyyy

[amitrathi239 · Accepted solution]

There is an issue with todate.write the format according the string format.

ToDate(Substr(UserResponse ([Posting]; "P2 Postingdate Ende");1;10);"MM.dd.yyyy")