date conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what expression should I use to convert text, formated as date (01/01/2000)
into a date data type?
 
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.
 
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?
 
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
 
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
Click to expand...
 
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#
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Converted from LINUX time ok, but having issues with the between date. 4
Access Running Balance in Access 1
Counts number of entries per day in query 4
Change a datefield to the first day in the given month? 5
Julian Date conversion 9
Change a field type from data to date/time?? 5
Count records in 10 minute time period 4

Back
Top