date - now = number

[westcoaststyle]

What do I need to do to subtract date1 from now() and return a number?

I want to show how many days are left from a specific date until Now().

Thanks!

 

[Guest_imported]

Hi...

Assuming that you are trying to get a number on a report.

Select Date from your query or table..(I am assuming you
have a date in your table). Create a text box
and place this in it:

=Date()-([Date])

This will give you a number.

GR

 

[westcoaststyle]

THAT'S IT! THANKS!

I just love it when I ask such simple questions.