Calculate days from a date field until now

240
1
Jump to solution
02-29-2024 02:02 PM
VictorSalazar
New Contributor

I am collecting a date of when someone moved in.  I then want a new field to automatically calculate the amount of days from that date.  

Does the calculation field need to be a 'calculation' type, or integer?  Also, what would the calculation look like to count the amount of days until now()?  

 

Thank you!

0 Kudos
1 Solution

Accepted Solutions
VictorSalazar
New Contributor

int((decimal-date-time(today()) - decimal-date-time(${locationlength})))

 

 

Got it... thanks.

View solution in original post

0 Kudos
1 Reply
VictorSalazar
New Contributor

int((decimal-date-time(today()) - decimal-date-time(${locationlength})))

 

 

Got it... thanks.

0 Kudos