DAYS Function adding a day
D
Daryll Donais
When using the DAYS function on a datetime field (where date and time are allowed). The function always adds 1 day. Eg.
Start Date set to: 06/27/2025 03:00
End Date set to: 06/27/2025 05:45
DAYS(field("End Date"), field("Start Date"))
outputs 1
So when I try to calculate the time difference in minutes, it is inaccurate.
Log In