Need to convert 05/22/2023 14:16:14 into 05/22/2023 02:16:14 PM

[RajatRehria]

Hi all how can i convert this date 05/22/2023 14:16:14 into 05/22/2023 02:16:14 PM  format using DateTimeParse formula?

[binuacs · Accepted solution]

@RajatRehria 

DateTimeFormat(DateTimeParse([Date],”%m/%d/%Y %H:%M:%S”),”%m/%d/%Y %I:%M %p”)

[DataNath · Accepted solution]

Hey @RajatRehria, you can do that with the following formula, using DateTimeFormat to achieve your desired format. Important to note that this will still need to be stored as a string due to the non-ISO standard:

DateTimeFormat(
DateTimeParse([Input],'%m/%d/%Y %H:%M:%S'),
'%m/%d/%Y %I:%M:%S %p')

[RajatRehria]

many thanks to both of you @binuacs and @DataNath for the solutions.