Changing Date/Time format

[senn2912]

Hi All,

Can someone please help?

I am struggling to change the format of 2013-07-29 11:33:03.6160000 to show dd/mm/yyyy

Thanks in advance,

G

 

[pr2-eugin]

How about using, DateSerial and Mid function together? You can use them in a Query as..

SELECT theOldDateField, 
[URL="http://www.techonthenet.com/access/functions/date/dateserial.php"]DateSerial[/URL](Mid(theOldDateField, 1, 4), Mid(theOldDateField, 6, 2), Mid(theOldDateField, 9, 2)) AS newDateField 
FROM theTableName;

 

[senn2912]

It seems the reason that i am also having problems is due to the fact my date format in my table is actually TEXT...

 

[pr2-eugin]

Sorry I am did you try the above? Did it not work?

 

[0nyx175]

Format (date, "Short Date")