Apr 25, 2008 #1 Oromia Programmer Feb 6, 2006 12 US Hi all, Is there a way a time format such as 4/24/2008 11:06:02 PM be converted to 11:06 PM (short format) using update query? Thanks
Hi all, Is there a way a time format such as 4/24/2008 11:06:02 PM be converted to 11:06 PM (short format) using update query? Thanks
Apr 25, 2008 #2 pbaldy IS-IT--Management Feb 7, 2008 120 US Date/time values are actually stored as a double, so your issue is simply a formatting one: http://support.microsoft.com/kb/210276/en-us Paul MS Access MVP 2007/2008 Upvote 0 Downvote
Date/time values are actually stored as a double, so your issue is simply a formatting one: http://support.microsoft.com/kb/210276/en-us Paul MS Access MVP 2007/2008