Covert Text to Date/Time Query 1

[marcoman44]

20031124

The above is stored as text in an Access DB. How do I convert to a Date/Time type.


Thanks in advance for any help.

 

[SkipVought]

hi,

Mydate = dateserial(left([MyField],4), mid([MyField],5,2), right([MyField],2)

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[AlexMidd]

The CDate function.

Have fun! )

Alex Middleton

 

[SkipVought]

FYI

Why do Dates and Times seem to be so much trouble? faq68-5827

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]