View Full Version : Input Parameter


TLW
01-31-2002, 11:29 AM
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
01-31-2002, 11:38 AM
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.

TLW
02-01-2002, 05:20 AM
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

TLW
02-04-2002, 07:06 AM
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