Why is it that I get #ERROR message (instead of date value) in my report when I use the formula
=ToDate(UserResponse("Enter End Date:");"dd.MM.yyyy") ??
When I only write UserResponse("Enter End Date:") I get the appropriate date, f.ex 5/12/2009. This is american standard for 5th of may, I need to see it like 12/05/2009.
If I try to just enter the date object behind the prompt ([Settlement Date]) i get message #MULTIVALUE even though I have promptet for 1 special date...
Is there another formula I can use to get the right format? I can't adjust the format using properties, it doesn't make any difference, the settings I put in there.