How would you parse a data string like this? 2

[glthornton]

Hi everyone,

I'm using Access 2000 and I'm trying to parse a data string like "3/19/2003 10:36:00 AM" into it's separate parts. What I need is:

Month=3
Day=19
Year=2003
Time1=10
Time2=36

Does anyone have a suggestion as to how this can be done?

Thank you,

glthornton

 

[SkipVought]

Hi,

Use the Year(), Month(), Day(), Hour(), Minute(), Second() functions.

Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

BTW, I assumed that this was NOT a string but a REAL DATE/TIME value.

If it is indeed a string, simply convert to a DATE/TIME Value...

s = "3/19/2003 10:36:00 AM"
d = DateValue(s) + TimeValue(s)
MyYear = Year(d)
MyHour = Hour(d)

Skip,
[sub]
[red][/red]
[/sub]

 

[IT4EVR]

You can also use the DatePart function

For example

 DatePart("h",[Date_Update]) AS Hours,  DatePart("n",[Date_Update]) AS Minutes

 

[glthornton]

Thanks Skip and IT as they are both valid ways of extracting the data. Awesome suggestions!!
glthornton