Countdown to an event

  • Thread starter Thread starter David Bauer
  • Start date Start date
D

David Bauer

I want to insert a field in a form to countdown the days
until an event occurs. I want the field to show how many
days until the last event expires. For example.

Joe Snuffy performed this task on 1-Jan-03. He has 90
days until he has to perform that task again. If today is
3-Jan-03 he has 88 days until that event has to be
accomplished again. I want the field to automatically
calculate and show the 88 days.

If you know how, please help.

Thanks very much,

david.
 
I think that on the Form OnCurrent event you could use

[field].Value = DateDiff("d", Date1 , Date2) + 1

See if that works. Cheers

Chris
 
David

DateAdd() is the function you should review in the help file. Additionally,
DateDiff() function is one that you should review too.

HTH

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top