help with number of days calculation

[NEWHERE]

I have two timestamp fields and need to find out the number of days between them.

You guys have been great answering all my questions. Thanks again.

Jean

[LaRetta]

Jean, it would help to know your version.

If vs. 7, here was a recent post which explains the concept of using timestamps. Thread towards the bottom (by Comment) specifically converts the difference to days for us.

LaRetta

[Eliz309]

Could you do this with v6?

[LaRetta]

I didn't realize someone else had stetpped in, sorry.

You can do it in vs. 6 but it takes more work. We need to know the fields involved.

L

[Eliz309]

No problem. of course it takes more work, we need to upgrade.

I would need to know the number of days difference between fields "today" and "dateoflastsale". They are both set to date fields and I tried to just subtract the two but I got some weird number.

[Ender]

Taking the difference between two dates yields the number of days between them. The result of the calc should be Number.

[Eliz309]

I had it wrong, I changed the 'days since last sale' field to a calulation field, from a number field. For some reason that fixed it. thanks so much for your help.

Edited August 10, 2005 by Guest

[NEWHERE]

Thank you, it worked!

As usual, you guys have been terrific.