Add dates and find difference

T

theryno

I have two fields [Date_of_File] and [Number_of_Days_To_Work] that I need to
add and then find the number of days left to complete. Basically do the
following:
([Date_of_File]+[Number_of_Days_To_Work])-Today(), but cannot get this to
work. Thank you!!
 
D

Douglas J Steele

Access doesn't have a Today function: it has Date() (which returns just the
date) and Now() (which returns the date and time)
 
Top