Input Parameter

[TLW]

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.

 

[Rich]

Use a custom form with an input mask, it's probably the easiest way

 

[David R]

Actually I think there's an even easier way. Try putting the # symbols around your parameter and it should convert it from any format.

 

[TLW]

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]

"Between # " & [Enter Shipping Dock Beginning Date:] & " # And # " & [Enter Shipping Dock End Date:] & " # "

I believe.
David R

 

[TLW]

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]

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