days since calculation

[krh]

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

[Lee Smith]

Get(CurrentDate) - A_Date

Is A_Date a Date field, or text?

Edited August 26, 2010 by Guest
A_Date

[comment]

Get(CurrentDate)-A_Date

If this is a calculation field, make sure it's unstored.

[krh]

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.

[comment]

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.