converting 12 hour time to 24 hour time

Hello again!

I recently posted another question about DateTime stuff that has since been resolved, however I have come across another issue and am wondering if there is a way to fix in Alteryx.

I have 2 columns of data, one being inquiry created date, the other being inquiry closed date. Both columns are DateTime data types. The issue here is that some of these dates/times up and down the column are in 12 hour time, whereas the rest are in 24 hour time. I am not sure which ones are in 12 hour time specifically, but I need all of the values to be in 24 hour time.

Does anyone know of a way I can fix this in Alteryx?

Any help you can provide is much appreciated. Thanks again!

Date Time

Help

Data Investigation

Accepted answers

Kenda

Hey @paigeblackstone

Referring to this article again, https://help.alteryx.com/current/Reference/DateTimeFunctions.htm, I would suggest using the following function:

DateTimeFormat(dt,f)

where

dt: DateTime data, expressed as a selected column or a specified DateTime value between quotes.

f: The format to which to convert the data, expressed in a format string.

At the bottom of this web page you will see a section called specifiers. Here it tells you that '%H' can return the 'Hour in 24 hour clock, 00 to 23.'

All comments

ivoller

Please post sample data.

The DateTime conversion tool is almost certainly your friend when it comes to converting from yyyy-MM-dd hh:mm:ss %P to yyyy-MM-dd hh:mm:ss but I'd need to see the data before offering more advice.

Kenda

Hey @paigeblackstone

Referring to this article again, https://help.alteryx.com/current/Reference/DateTimeFunctions.htm, I would suggest using the following function:

DateTimeFormat(dt,f)

where

dt: DateTime data, expressed as a selected column or a specified DateTime value between quotes.

f: The format to which to convert the data, expressed in a format string.

At the bottom of this web page you will see a section called specifiers. Here it tells you that '%H' can return the 'Hour in 24 hour clock, 00 to 23.'

DanielG

https://help.alteryx.com/current/en/designer/functions/datetime-functions.html -- updated link to datetime functions as the above link goes to 404 error

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703