date conversion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George Walters - 19 May 2006 23:31 GMT

what expression should I use to convert text, formated as date (01/01/2000)
into a date data type?

Reply to this Message

Douglas J. Steele - 20 May 2006 00:28 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> what expression should I use to convert text, formated as date
> (01/01/2000)
> into a date data type?

Reply to this Message

George Walters - 20 May 2006 00:42 GMT

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?

> 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
[quoted text clipped - 3 lines]
> > (01/01/2000)
> > into a date data type?

Reply to this Message

Jeff Boyce - 20 May 2006 00:54 GMT

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

>I am a novice: can you tell me what the exact CDATE expression would be?
>
[quoted text clipped - 10 lines]
>> > (01/01/2000)
>> > into a date data type?

Reply to this Message

George Walters - 20 May 2006 02:34 GMT

No help from "help."

> Pardon my intrusion...
>
[quoted text clipped - 20 lines]
> >> > (01/01/2000)
> >> > into a date data type?

Reply to this Message

Duane Hookom - 20 May 2006 02:59 GMT

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#

Signature

Duane Hookom
MS Access MVP

> No help from "help."
>
[quoted text clipped - 25 lines]
>> >> > (01/01/2000)
>> >> > into a date data type?

Reply to this Message

Vsn - 20 May 2006 17:21 GMT

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/3
b133369-8b81-4b7a-a88d-597a1c4f7f1a.asp

Enjoy.

> No help from "help."
>
[quoted text clipped - 25 lines]
>> >> > (01/01/2000)
>> >> > into a date data type?

Reply to this Message