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!
Hi @htja -
My suggestion is
- Create a new calculated field.
- Add this logic → datediff(‘YYYY’, {start_date}, {end_date})
- From the field wells column dropdown please select “Hour” (as shown below)
I hope that helps.
2 Likes