Forum Discussion

Post Patron

10 years ago

Time difference in hours

Hi, I'm trying to calculate the diiference in hours between two date/time columns. When I use DateDiff I am not able to use the two columns below.

Post Patron

10 years ago

I'm confused. When I type DateDiff( I don't get the TimeFrom or TimeTo columns for selection in the measure.

If I use a calculated column I do but get the above error.

Community Champion

10 years ago

android1 You have to create a COLUMN - NOT a Measure!

Look at the picture in my post above - you can't do this as a Measure - that's why the columns are not showing up when you type!

click New Column - then you'll see the columns will show up after you type DATEDIFF