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

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

Could you do this with v6?

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

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.

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

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, 200520 yr by Guest

Thank you, it worked!

As usual, you guys have been terrific.