I am linked to a table with "INVDATE" not being a date/time field...it is a text 8 field. Can I still use a BETWEEN [Invdate Start] and [Invdate End] parameter query? Is there a way to convert the text field so the parameter query works correctly...My INVDATE field is mm/dd/yy, slashes already there.
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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CDATE Function?
- Thread starter dridge
- Start date
DougP, MCP- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question