Calculating how many days left till deadline (1 Viewer)

[Marbinski]

I have a table that has key dates for a production.
Basically I am trying to create a QRY that can produce the actual date or the total amount of days left before the deadline date.

But the catch is here:
Example:
Sales Begin Date (Field)
01/01/05 (Field Value)

What I need:
Deadline Date = Sale Begin Date - 60 Days

If possible I also need:
Days left before Deadline = Deadline Date - Todays Date
-------------------------------------------------------------------
I need to notify certain people 60 days before Sales Begin (deadline date). Basically, I only have the Sales begin date, but I need to create a query that will give me the deadline date (60 days).

I've been playing with Date() but can't seem to get exactly what I need.

I hope my problem is described well enough. If anyone has any suggestions please help. Thanks a lot in advance.

 

[FoFa]

Try DateAdd function or maybe DateDiff depending on what you are trying to do

 

[Marbinski]

Thanks,
I did some searches on those functions on the forum...they helped a lot!!!!