Convert Date Time format

[kostaskir]

Hello guys,

I import an XML file in my database and I produce a report. One of the fields that I use has Date Time Format (27/04/2010 11:09).



My boss asked me to change this string: 27/04/2010 11:09 to 201004271109. Without special characters and the date time from dd/mm/yyyy hh:mm to yyyymmddhhmm .


Thanx in advance



Any thoughts?

 

[John.Woody]

Look at the datepart function, you could use this to select each part and re-arrange.

 

[namliam]

Try using the FORMAT function

 

[MStef]

I suggest, leave it in the table in format dd/mm/yyyy hh:mm (as it is),
but, in the form (for your boss) show it in the format yyyymmddhhmm.
Look at "DemoDatetimeA2002.mdb" (attachment, zip).
Look at Table1, Form1.
Open form1 and see.