Skip to main content
Question

Calculating months between dates

  • January 30, 2018
  • 0 replies
  • 50 views
I need to return a string if a date is falling in next 6, 12, 24 month.  I tried to use the following to construct first line but does not look like I have got this right. 

If(AdjustMonth([Lease Expiry],6)< 6, "Next 6 Months")

Could someone help? 
      This topic has been closed for replies.

      Try this

      If(
      isnull([lease expiry], "Missing Lease Expiry",
      AdjustMonth([Lease Expiry],0) <= Today(), "Expired",
      AdjustMonth([Lease Expiry],-6) <= Today(), "Next 6 Months",
      AdjustMonth([Lease Expiry],-12) <= Today(), "Next 12 months",
      AdjustMonth([Lease Expiry], -24) <= Today(), "Next 24 Months", "More that 24 months)
      )
        • ArshadKhwaja
        • Author
        • Registered
        • January 30, 2018
        Mark

        As always learning from you. Many thanks. 
        Terms & ConditionsAccessibility statement