Date Diff (1 Viewer)

[mike60smart]

Hi Everyone

I need to calculate the number of Days between 2 dates.

StartDate and TermDate

I know how to use the DateDiff Function

=DateDiff("d",[StartDate],[TermDate])

How would I cater for the TermDate being Black and If it is Blank then use the Current Date.
Any help appreciated.

 

[Minty]

Use an NZ around the TermDate?

 

[The_Doc_Man]

First, always put the later date first in DateDiff unless it is OK to come out with negative numbers.

Second, this would also work: = FIX( NZ( [TermDate], Date() ) - NZ( [StartDate], Date() ) )

And my usage also shows you how to use NZ and the current date.

 

[mike60smart]

Hi Minty

Many thanks that solved it