Skip to Content
Dec 09, 2016 at 05:04 PM

What is wrong with this syntax?


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!