Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using the Parameter Prompt

Status
Not open for further replies.

clifpa

IS-IT--Management
Jun 8, 2001
2
US
I created a Parameter Prompt selecting a field from a SQL table, i.e., String
'01Jan01 13:00p' as part of a range date check.

My problem is that I don't want to have the user enter the time portion of the string, enter '01Jan01' only, mask doesn't work.

Where and when should I parse/truncate the string and perform the range check on the two date entries and using what code?

Thanking you in advance.

First time.

 
Have you setup the Parameter so that it is in just Date format. This is what I have done and it works fine.

If you need to know how do set it let me know.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top