ccyymmdd to dd/mm/yyyy from query

A

Andy

I have data coming from an ODBC connection which comes in as text format in
the format ccyymmdd. I need to convert this to dd/mm/yyyy with a format of
date/time in a table outputting from a make table query.

I can easily get the form dd/mm/yyyy with some concatenation, but want to
make this field with the format of date/time...

Help appreciated.
 
O

Ofer Cohen

Try

NewDate:
DateSerial(Mid([FieldName],3,2),Mid([FieldName],5,2),Right([FieldName],2))
 
A

Andy

Long-winded, but hey it works!

Cheers

Ofer Cohen said:
Try

NewDate:
DateSerial(Mid([FieldName],3,2),Mid([FieldName],5,2),Right([FieldName],2))

--
Good Luck
BS"D


Andy said:
I have data coming from an ODBC connection which comes in as text format in
the format ccyymmdd. I need to convert this to dd/mm/yyyy with a format of
date/time in a table outputting from a make table query.

I can easily get the form dd/mm/yyyy with some concatenation, but want to
make this field with the format of date/time...

Help appreciated.
Click to expand...
Click to expand...
 

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

How to use/create code in MS Word to calculate age? 0
VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Forcing a date entry format of dd/mm/yyyy 1
Converting Birth Date format 1
How to enter a date in DD-MM-YYYY format 2
Issue with OLE DB Query - Date Search 0
Format Date "dd/mm/yyyy" 0

Top