Date Picker as Input for Variable

[Former Member]

I have a basic query with 0CALDAY as a mandatory variable in my query. I want to use Date Picker in the input form, so the users sees a calendar to choose which day to use. When I use pate picker in the input form, it is stored as a 'D' date field. 0CALDAY on my query is a 'T' text field. So it will not allow me to assign the date as an input. I tried using the formula expression to convert the D date to a T text, but was unsuccessful. My formula was DSTR (@0CALDAY,DDMMYYYY).

Any ideas or help? Points will be awarded.

Thanks

Jeff

[Former Member]

Solved my own issue. Figure out I had two problems. First, I had another "KEY_DATE" in the selection which was conflicting. Second, the code DSTR(@0CALDAY,'ddmmyyyy') was in lowercase. Must be 'DDMMYYYY')