DATETIME and FORMAT Function

efassetta

Hello,

i need to have a field conteining only the hour.

If i use the TIME function it gives me the time but in a format unusable for my scope.

There is the possibility to use the FORMAT function? If yes which is the correct syntax for my scope?

Thank's in advance.

Nagi

How about using COPYSTR(FORMAT(TIME,1,2))? That would return the current hour.

stryk

Or try

FORMAT(TIME,0,'<Hours24>')