Formula - Function HOUR does not extract hour from a date (with hour set)

Hi,

I am trying to use HOUR() on a date but does not seems to extract the hour set in the date :confused:
Am I using if right ?

The formula :
image

The result :
image

Thanks for your help.
Caroline.

Hi @carolin-skiply do you have the answer on this already?

I am also struggling to extract the exact value of hour from a Date column.

Is there any news in this topic?, this a basic formula and I can’t get it done.

Thanks in advance

1 Like