Date comparing

[sculptorlv]

Please help! Can't get the right logic to compare dates.

I have variable DateX (the start date of the contract)

I have today date Today()

How can I get the answer,

   if 3 months is passed from the DateX date?

[tresesco · Accepted solution]

If( AddMonths(DateX, 3) < Today(), '3 months passed' , 'Not yet')

[sculptorlv]

Thank you. This works.

I used the same logic .. but made mistake in another expression .. thus was looking for another solution.

Thank you once again.

[berndjaegle]

Be aware, that AddMonths() will not cut the time Information from your DateX. Today() on the other hand has time 00:00:00. In my case I had to floor my date.

date(floor(<DateX>), 'MM/DD/YYYY').

[sculptorlv]

Thank .. I guess this info could help me in my previous solution logic