I’m trying to get the difference between a datetime in a last modified field and a datetime in a regular date field. When I input the current date and time into the date field (so the last modified date and time becomes the same), the date_diff function gives me a difference of 5 or -5 hours. As it turns out, my time zone is UTC-5.
So, either date fields or last modified fields aren’t respecting time zones. When I put the date field as the second argument and the last modified field as the third argument in date_diff, I get positive 5 for the difference in hours, so I think that means that date fields are in UTC and last modified fields are in local time.