countdown timers

[Gabe]

HELP!! I need to insert a date function into my
database. Really what I need is a "countdown timer" that
indicates how many days are left until an order needs to
go out. I have been experimenting with the "NOW()"
expression but get a long interger that will not suffice.

 

[Wayne Morgan]

Now() returns the current date and time. Date() will return the current date and Time()
will return the current time. Once you have what you need, also check the DateDiff and
DateAdd functions in VBA.

I believe you will find that using the DateDiff function to compare the current date with
the due date will give you what you need.

=DateDiff("d", Date(), [DueDateField Or Value])