conversion of datetime field into hour

[jayati_shrivast]

Hi All,

I have a date field as DD-MM-YYYY hh:mm:ss.

I need to make a graph with date on x axis and count of measure on y axiz.

But on x axis the date field should be represented on hourly basis. How can I convert the field into hours. the hours should be a 24 hour format.

please help me

Thanks

[sunny_talwar · Accepted solution]

Have you tried the Hour() function?

Hour(DateField)

[jayati_shrivast]

Thanks. it worked