Calculate a date range
Does anyone know how to make a calculation take a start date and subtract it from the present date to output total number of days? Essentially I have a membership list with a "join date" field and I want to be able to output how many days they've been a member to use for other analysis.
Thanks!

Hej, calculation fields are stupid. If you have first just put in a date, the calculation field tries to give out the number as a date. But it can't cause it is a number. Just delete the calculation field, insert a new one, paste the skript and fill in date @A0. After that it should work.
Please sign in to leave a comment.
Comments
10 comments