Forum Discussion

BrittonPurin's avatar
BrittonPurin
Qrew Member
6 years ago

How to Work with Date/Time to create days until

​Good Morning. I am building an app and having trouble with the Date/Time format while trying to make a display of when assignments are coming up or past due.  I have the formula below but the first l...
Formulas and functions
BrandonDrake's avatar
BrandonDrake
Qrew Cadet
6 years ago
Hello Britton, 

You should be able to just put ToDate() in the variable to calculate the number of days and see if that fixes the issue. 

var number numberdays = ToDays(Today()-ToDate([Due (Date/Time)]));

------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------