I'm creating a detail object to convert a string to date/time.
= FormatDate ( [Recon Performed Date & Time] ; "MM/dd/yyyy hh:mm:ss AM ")
The value of [Recon Performed Date & Time] = 10/02/2016 11:52:41 AM but the variable show up like:
10/02/2016 11:52:41 AM10
I've looked for different mask settings but all of the variations fail.
How can I eliminate the "10" after the AM?
Thank you in advance for your time and help!