Add 6 months to an existing date

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?

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

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

Hi Levent

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

Many thanks
Paul

1 Like

You’re welcome