Add 6 months to an existing date

[Paul_Grindley]

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?

[LeventK · Accepted solution]

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]

[Paulo]

Thank you for your solution! I have a question: When my [Start_Date] is before February the formula works fine, but when it's after February the result is missing a couple days. Is there any workaround for this issue?

[Steve]

Please start a new topic for help with this.

[Paulo]

Thank you @Steve !

[Paul_Grindley]

Hi Levent

That’s perfect. I couldn’t figure out that EOMONTH syntax but your formula does exactly what I need.

Many thanks
Paul

[LeventK]

You’re welcome