Calculating Datediff from filter end date

Question & Answer
1

Hi there! Need help calculating a datediff. In this image, looking to calculate the difference between “end date” and the latest time returned in the table (June 15 at 10:07am). I need it returned in hours. Please help!
image

2

Hi @htja -

My suggestion is

  1. Create a new calculated field.
  2. Add this logic → datediff(‘YYYY’, {start_date}, {end_date})
  3. From the field wells column dropdown please select “Hour” (as shown below)

QS

I hope that helps.

2 Likes