G
Guest
what expression should I use to convert text, formated as date (01/01/2000)
into a date data type?
into a date data type?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
Try CDate. If that doesn't work, you'll have to parse it into the day, month
and year (using some combination of Left, Mid and Right) and plug those
pieces into the DateSerial function.
and year (using some combination of Left, Mid and Right) and plug those
pieces into the DateSerial function.
G
Guest
I am a novice: can you tell me what the exact CDATE expression would be?
The date serial has been suggested before, but I couldn't figure out the
right expression based on 01/01/2000 text format. Can you help with that too?
The date serial has been suggested before, but I couldn't figure out the
right expression based on 01/01/2000 text format. Can you help with that too?
J
Jeff Boyce
Pardon my intrusion...
You might be able to use Access HELP and find the valid syntax for the
CDate() function.
Good luck!
Jeff Boyce
Microsoft Office/Access MVP
You might be able to use Access HELP and find the valid syntax for the
CDate() function.
Good luck!
Jeff Boyce
Microsoft Office/Access MVP
G
Guest
No help from "help."
Jeff Boyce said:Pardon my intrusion...
You might be able to use Access HELP and find the valid syntax for the
CDate() function.
Good luck!
Jeff Boyce
Microsoft Office/Access MVP
D
Duane Hookom
Some times you need to open any module and press [F1]. CDate() is like any
other function. It expects a legitimate string date value and converts it to
a real date.
CDate("01/01/2000") = #1/1/2000#
other function. It expects a legitimate string date value and converts it to
a real date.
CDate("01/01/2000") = #1/1/2000#