How to compare the dates

[sabavno]

Hi,

I wonder if anyone knows how to compare the dates. What I need to is the following:

I need to count difference in number of months from the start date to the current month.

Suppose, my start date was April 2002 and the current date is May 2003, then I need to come up with the number 15 as a difference between these two months.

Please help

Thanks.

 

[pmonett]

You have two possibilities. One is using Formula language, with the simple sustraction of two date/time fields. Note that the result is in seconds, so calculate accordingly.
The other solution is to use LotusScript. Create two NotesDateTime items and use the TimeDifference method.
You'll find all the info you need in the Designer Help.

 

[rajeevturlapati]

One easy way of comparing dates is using formula language ,
try out this formula

@Month(@Now)-(@Month(@Created))

Hope this Helps