View Single Post
 
Old 10-25-2016, 06:45 AM
ShankedS ShankedS is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Oct 2014
Posts: 62
ShankedS is on a distinguished road
Default

Follow-up question:

I put in the following for the field:
Code:
CREATEDATE mm/dd/yyyy h:mmAM/PM
My anticipated output was the following:
Quote:
10/25/2016 9:45AM
What I got was:

Quote:
10/25/2016 9:39:00 AM


Clearly I misinterpreted something?

EDIT: I got the format how I wanted it, but I'm still confused as to why I couldn't get the AM/PM to be immediately after the time (no space) and why seconds were showing when I didn't include them in the field codes.
Reply With Quote