UTC now 12 / 24 hour format

[Anonymous]

Hi all,

I've recently been using "@{utcnow('hh')}" to return the current hour. I was naively expecting this to be in 24 hour format by defaulty but its in 12 hour, i.e. 0-12.

Does anyone know how to get the current hour in 24 hour format? Its a pain to test during office hours!

Thanks,

Eddie

[v-yamao-msft · Accepted solution]

Hi Eddie_Thomas,

To get the current hour, the function I am using is “@formatDateTime(utcnow(),'HH')”.

I also tried with your function, please just modify your function to “@utcnow('HH')”.

This doc about “Custom Date and Time Format Strings” could be a reference for you, please check it for more details about the difference between “hh” and “HH”:
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

Best regards,
Mabel Mao

[Anonymous]

Thanks @v-yamao-msft That worked perfectly!

[v-yamao-msft]

Hi Eddie_Thomas,

Glad to hear that it works for you.

Any time you have issues when working with Flow, please feel free post your issues here, we are always ready to help.

Best regards,
Mabel Mao

[YankeeSierra]

Thanks!!!