August 26, 201015 yr I am trying to get the number of days since a person has checked in... Get(CurrentDate) - Month(A_Date);Day(A_Date);Year(A_Date) Get(CurrentDate)-A_Date I have tried everything that i can think of. thanks for your help
August 26, 201015 yr Get(CurrentDate) - A_Date Is A_Date a Date field, or text? Edited August 26, 201015 yr by Guest A_Date
August 26, 201015 yr Get(CurrentDate)-A_Date If this is a calculation field, make sure it's unstored.
August 26, 201015 yr Author Thanks for your help guys.... I have it as a calculation and set as a text field. Also, unstored. It doesn't give me the correct numer of days it gives me... -20:02:32.
August 26, 201015 yr I have it as a calculation and set as a text field. Not sure what you mean by that. A_Date must be a Date field. The other field should be a Calculation field, unstored, with result type set to Number.
Create an account or sign in to comment