Query parameter date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a query parameter for a date field. I can create the
parameter, but when the input box pops up, no matter what date format I put
in, I get the following error message:

Illegal data: '{ts '20'.Expected format.'Default Datetime Mask'

The format of the data in that field is yyyy/mm/dd
 
Terri D. said:
I'm trying to create a query parameter for a date field. I can create the
parameter, but when the input box pops up, no matter what date format I put
in, I get the following error message:

Illegal data: '{ts '20'.Expected format.'Default Datetime Mask'

The format of the data in that field is yyyy/mm/dd
Click to expand...

Have you tried yyyy-mm-dd (or yyyy-mm-dd hh:mm:ss)?

Jamie.

--
 
Back
Top