How to calculate remain days using dates?

[jimrawr]

I am trying to do this in a form. I have an Epiration date, and I need to calculate remaining days...

I.E Epiration date = 12/25/05
Todays Date = 10/10/05

Remaining = 12/25/05 - 10/10/05

Can someone tell me the code that needs to go into the control source? Thanks!!

 

[jrbarnett]

=datediff ("d", Date(), ExpiryDate)

- Replace ExpiryDate with the name of your field.

John

 

[TheAceMan1]

How are ya jimrawr . . .

For working days between two dates, have a look here:

How to Find Number of Working Days Between Two Dates

See Ya! . . . . . .

 

[jimrawr]

Thanks for the help guys...

I havent had a chance yet to check the code, but does that code jrbarnett gave calculate using the system date? Thats what I need... Expiration date - system date = days left

 

[jimrawr]

yup, it did thanks!!