Query parameter date format

T

Terri D.

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
 
J

Jamie Collins

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

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

Jamie.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top