I have specified an input parameter to prompt for a date range when opening a report. Is there some way to allow the parameter to be passed as any date format.
Hence, the user could type 02/01/02 or 2/1/02 or 2-1-02 or 02-01-02 ... Thanks for any help.
Use a custom form with an input mask, it's probably the easiest way
David R
01-31-2002, 12:00 PM
Actually I think there's an even easier way. Try putting the # symbols around your parameter and it should convert it from any format.
Here is my criteria:
"Between [Enter Shipping Dock Beginning Date:] And [Enter Shipping Dock End Date:]" for the input. I have the expression for this parameter formatted as following:
"DateStamp: Max(Format([ccpTimeStamp],"mm\dd\yy"))"
When I tried to insert the # into the criteria I received an error. Could you elaborate on how this should be setup.
David R
02-01-2002, 10:43 AM
"Between # " & [Enter Shipping Dock Beginning Date:] & " # And # " & [Enter Shipping Dock End Date:] & " # "
I believe.
David R
Well I tried with that syntax and this did not work either. If you have any other ideas please let me know, if not thanks for your help.
boblarson
02-06-2002, 11:32 PM
I tried setting up a query with date input parameters and then built a report for it. I didn't have any problem getting the correct data when I used:
03/01/2001, 03-01-2001, 3-1-2001, 3-1-01, 3/01-2001, and more.
So, it should pull the right data if you use ANY format with the date field.
BL
hth