calculate length of stay

[wdisneymom]

I have a lsit of clients who are on a waiting list for services

I have a field "today" which changes every day

I have a field certification date

I need to calculate the time on the waitlist so I did

los=today-certification date

I get a very long number like 739910

How do I get it right

[Vaughan]

change the los field to

Get(CurrentDate) - CertificationDate

and make sure it is formatted as a number field.

The Certification field needs to be a Date field.

[wdisneymom]

thanks, it worked

[wdisneymom]

so...why won't the same formula work with today's age

get(currentdate)-dob

[-Queue-]

Make sure the calc is unstored, so that the date updates.

[GlennC]

I'm trying to do date1 - date2 to get then number of days in between. Date1 is more recent. Am not using 'Today' or any function, both dates are already entered into the fields. Calc is formatted to give a number result.

It doesn't seem to work. For instance (dd/mm/yyyyy)

03/02/2005 - 06/01/2005 = -5280025

What am I doing wrong?

[mr_vodka]

Have you double checked that both Date1 and Daet2 fields are set as "Date fields" ? If they are set to text of number, etc. you sometimes get those long results.

[-Queue-]

If that doesn't help, please post a sample of the problem file.

[GlennC]

Ahhh.... field 2 was a number field.

Not one of my brighter moments.

Thanks for the help.