I am using the Database Region Wizard to run a query on a table in an Access database. The table field I must query off in Access is a Date/Time field in Short Date format (3/12/99). Unfortunately, the FrontPage text box I created needs to send a date formatted result to the asp script to run the Select query from Access. Since I cannot figure out how to have the text form field convert the date the user enters in to an actual Date/Time format that Access understands I am getting a Data Type Mismatch error. If I run the query on a text field in Access it works fine. Any suggestions on converting a text date to a valid date format?? The trick being that the date the user enters is always going to vary.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.