Date comparison

Questions and Help
1

Need some quick help here. I want to check if the move out date is after the lease expiration date and if it is show the MTM increase field. Can someone help me out with this?
Thanks in advance!

{note}
CALCULATE MOVE OUT FUNDS
Monthly rent: ${=`current rent`}
Lease expiration date: {time: MM/DD/YYYY; at={=`lease expiration date`}; pattern=YYYY-MM-DD}
Move out date: {formdate: YYYY-MM-DD; name=moveoutdate}
MTM increase %: {formtext: name=mtm; default=0}
{endnote: trim=right}

2

Hi Stephanie,

You want to use the datetimediff function.

Here is an example:

Date 1: {formdate: YYYY-MM-DD; name=d1}
Date 2: {formdate: YYYY-MM-DD; name=d2}

{diff=datetimediff(d1, d2, "D")}

The dates are {=diff} days apart.

{if: diff > 0}
Date 1 is before Date 2
{elseif: diff < 0}
Date 2 is before Date 1
{endif}

2 Likes