- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 14, 2022 03:10 PM
I have a “Next Year End” date field for each of our clients and then I have fields for each of the 4 quarters to populate dates in various other tables. I am trying to create a formula that will take automatically choose the last day of the month when I use this formula:
DATEADD({Next Year End}, 6, “month”) - it basically brings me to October 30th, not October 31st.
Does anyone know what I’m missing? I’ve been looking everywhere in here…It doesn’t seem like this should be so difficult unless I’m totally not understanding :slightly_smiling_face:
Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 15, 2022 03:40 AM
Hi @Michelle-T ,
I don’t see any other way except to return the month from this formula and then hardcode the date based on the month So basically you write down if the month is Jan Mar May etc. then 31 and if April June etc. 30 and if Feb 28