Date time format military time to class room time

Question

Hi All,

I have an one date field in my table it showing the time in military time format like 2018-04-01 18:50:18 but my requirement is I need to convert this to class room time format.

O/p should be: 2018-04-01 6:50:18 PM

If you have any ideas please help me to resolve this.

Thanks,

Deepak.

ivoller · Accepted Answer

Try DateTimeFormat([Date],"%Y/%m/%d %I:%M:%S %p")

See attached

LordNeilLord · Accepted Answer

Hey @DeepakKrish

You can use the follow format: %Y-%m-%d %I:%M:%S %P either in the formula tool (dateTimeFormat) or in the dateTime tool

This webpage is really helpful https://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm