HI,
Can I have the tool to know whether the date/time read in is either AM or PM?
AM or PM designation?
Hi @Archaeopteryx
Do you really have to use the DateTime tool?
Using the DateTimeParse function, you can specify AM/PM with the "%X" parameter.
Cheers,
Hi
and thank you for the reply. Can you elaborate? 'How' to use the %X parameter? I have Particle status.
Hello there @Archaeopteryx and @Thableaus
Touching again on this subject, here is a sample of how to parse date time coming in 12 hour format with the AM/PM specifier; please note that when the specifier is on PM, it adds 12 hours to the parsed date time.
I guess that the key to it is to use the %I and %P specifiers on the format side of the formula's parameters.
Hi @Thableaus how can i convert this date 05/22/2023 14:16:14 into 05/22/2023 02:16:14 PM using DateTimeParse formula?
AM or PM designation?
