Calc months left with no negatives

[Guest]

I'm using the following formula in a query to calculate the number of months
left on a lease based on a set end date and todays date:
MonthsLeft: DateDiff("m",Now(),[EndDate])

I dont want it to display negative numbers though for leases that have
finished.
How do i get it to show a "0" for dates that have already past or if the
number is going to show a negative

thanks
Daniel

 

[Van T. Dinh]

MonthsLeft: IIf( [EndDate] < Date(), 0, DateDiff("m", Date(), [EndDate]) )