This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Add 6 months to an existing date

Posted on 07-14-2020 03:17 PM
Paul_Grindley
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hello

I have a field (Start_Date) and based on this date I want to initially populate another field (Expiry_Date) based on this date. So it should be Expiry_Date=Start_Date + 6 months.

I thought I could use the MONTH expression but Iโ€™m struggling?

Solved Solved
1 6 689
Topic Labels
Jump to Solution
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
LeventK
Silver 5
Silver 5
Reply posted on --/--/---- --:-- AM

Basically it is:
[Start_Date] + 180
But if you explicitly want to calculate it in exact days:

EOMONTH([Start_Date],6) - EOMONTH([Start_Date],0) + [Start_Date]

View solution in original post

Jump to Solution
6 REPLIES 6
Top Labels in this Space