0

Minus 1 month/4 weeks from date

I have a date field where a user puts in requested delivery date. I then need to calculate the date 4 weeks/1 month prior to that date. How can I do that?

 

Ideally the calculated date would be a formula so it can't be edited.

1 reply

null
    • Birger_H
    • 5 yrs ago
    • Reported - view

    4 weeks back:

    –––
    date(year('requested delivery date'), month('requested delivery date'), day(requested delivery date) - 28)
    –––

    One month back:

    –––
    date(year('requested delivery date'), month('requested delivery date') - 1, day('requested delivery date'))
    –––

    Birger

Login to reply

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 1172Views