0

trying to add 6 months to a date

Hi I have trying to add 6 months (ideally less 1 day) to a date.

The formula I am using is

date(year(date('Format date')), month(date('Format date')) + 6, day(date('Format date'))),

But as you can see from above.  It's added 3 months to the date.  And change the date to 1970!

 

Your help is greatly appriciated

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 8 mths ago
    • Reported - view

    This works for me: date(year(Datefield), month(Datefield) + 6, day(Datefield))

    And somehow Ninox takes in account if the sum of the month is bigger than 12, the year is adapted too.

      • Peter_Oram
      • 8 mths ago
      • Reported - view

      Perfect thank you very much

Login to reply

Content aside

  • Status Answered
  • 8 mths agoLast active
  • 2Replies
  • 43Views
  • 2 Following