Need the difference between two dates? No problem 😀
Use one of the following expressions. Trevor will calculate DATE_1 - DATE_2 and return an interval.
- diff_in_seconds(DATE_1, DATE_2)
- diff_in_days(DATE_1, DATE_2)
- diff_in_weeks(DATE_1, DATE_2)
- diff_in_months(DATE_1, DATE_2)
- diff_in_years(DATE_1, DATE_2)
*You can also use now(), which returns the present time, as one of your dates.
🕑 Need to find the difference in minutes or hours?
Using the diff_in_seconds function and dividing the result by 60 will give you the answer in minutes:
diff_in_seconds(DATE_1, DATE_2)/60
Dividing that result by 60 again will give you the result in hours:
diff_in_seconds(DATE_1, DATE_2)/60/60
---------
Have a question? 🧐
We're on standby to help! To chat with us, click the blue Intercom button in the bottom right of Trevor's interface.