Yes

[system]

I am at my wits end as I have Desktop Intelligence and I am trying to get a UserResponse Date Prompt to format into a proper date to use with a Days Between formula and I keep getting a "wrong data type error message. This is the variable I am using =FormatDate(ToDate(UserResponse(“Query 2 with ETM - MA Universe” ,“BEG DATE”) ,“dd/Mmm/yy”) ,“mm/dd/yy”). I have used something similar in Business Intelligence and it worked perfectly. Any help would be greatly appreciated. Thank you.

---

frederic.brock (BOB member since 2018-04-21)

[system]

Might be something to do with

ToDate(UserResponse("Query 2 with ETM - MA Universe" ,"BEG DATE") ,"dd/Mmm/yy") 

Try putting it in a column or cell just to check that you are getting what you are expecting. You could do the same with BEG DATE.

---

charlie (BOB member since 2002-08-20)

[system]

Not at my work yet so cannot confirm if it is as simple as mm/dd/yyyy should be upper MM/dd/yyyy.

---

Macroman (BOB member since 2002-11-13)