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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CDATE Function?

Status
Not open for further replies.

dridge

IS-IT--Management
Joined
Mar 5, 2001
Messages
8
Location
US
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.
 
maybe

=cdate(yourdate)
or
=format(yourdate, "mm/dd/yy") DougP, MCP

Visit my WEB site to see how Bar-codes can help you be more productive
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top