Hello all,
In access query ,I only need to get the date 31/12/2012 for example from the following :
31/12/2012 9:18:35 AM which is datetime value.
How can this be done please?
Novice
Windows 7 32bit 
Access 2002
Hello all,
In access query ,I only need to get the date 31/12/2012 for example from the following :
31/12/2012 9:18:35 AM which is datetime value.
How can this be done please?
Who is John Galt?
Windows XP Access 2007
Try the DateValue() or Format() functions.
VIP
Windows 7 64bit Access 2010 32bit
You are showing date as dd/mm/yyyy. Access expects mm/dd/yyyy. Review http://allenbrowne.com/ser-36.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 32bit Access 2002
Actually i am trying to create the query in access which is linked to an SQL server , maybe that's why the date have the following format.
Who is John Galt?
Windows XP Access 2007
Did you try either of the functions I suggested?
Need to convert date to a format compatible with MySQL's datetime object
Posting Permissions
Reply With Quote