Spotfire Ideas Portal
EOMONTH() is a common Excel function because in many cases, users (all Oil & Gas industry) need to compute information based off the end of the month.
Currently a typical user will not know how to compute the End of the Month using formulas because it is not trivial (like using an out of the box function; like in excel) and therefore google for help. Most suggested solutions on Google are not accurate because they do not work for dates in December. I have yet to find one that is accurate and works for dates in December but my formula that also works for December is also very large and scares users that simply use a function in Excel.
(Repost because I forgot to uncheck the new box for limiting it to my org)
Agree, this should be a built-in function. It CAN be done reliably using a calculated expression, as a workaround:
DateAdd('day',-1,DateAdd('month',1,Date(Year([DateField]),Month([DateField]),1))))
Inside out: Build a date that is the first of the month, add a month, then subtract a day.
Hi Hector,
We developed a custom SDN that has many extra formulas available such as this.
Works with leap years in Feb too.
EOM(Date(2020,01,15),1) > 2/29/2020 (End of current month, +1)
Offset is optional
Another is Workday.
See attached