Apr 25, 2008 #1 Oromia Programmer Joined Feb 6, 2006 Messages 12 Location 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 Joined Feb 7, 2008 Messages 120 Location 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