DateDiff Using Now()

[jeffshex]

I need to know how to make it so that the specified date is counted as 1 day already.
I have

=DateDiff("d",[appDate],Now())

For example, if my appDate is 2/28/06, the result I get is 13.

I need to find out how I can have it treat the appDate as 1 day so my result would of been 14.

Would it be easier to cheat and just put a + 1 on the end of that line? Not sure what the best approach would be, so any advice???

Thanks all!!!

 

[Golom]

In this instance cheating (+1) is encouraged. DateDiff returns the number of days elapsed since [appDate]. Obviously, on [appDate], no days have yet elapsed.

 

[PHV]

=Date()-[appDate]+1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886