0

Calculating at date help please

I need to calculate a date but cant work out how to do it.

Date + number of months from a multiple choice = new date.

Eg, 12/12/18 + 6 months (number from multiple choice) = 12/5/19

Any ideas?

2 replies

null
    • Nick
    • 5 yrs ago
    • Reported - view

    I have something similar as Trigger after update:

    'New Date' := date(year(Date) + 1, month(Date) + 6, day(Date)

     

    I hope it helps

     

    Nick

    • Nick
    • 5 yrs ago
    • Reported - view

    Please ignore my previous post :-(

     

    Please try this:

     

    let m := chosen(Your multiple choice);
    date(year(Date), month(Date) + number(m), day(Date))

     

    Nick

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1351Views