3 years ago
MONTH_LAST_DAY
What's new?
MONTH_LAST_DAY is a function that calculates the last day of a month based on a given date which has to be a column name.
Why does it matter?
Unlock a new transformation to perform critical date calculations directly in the Web App.
How does it work?
Syntax -> MONTH_LAST_DAY (transaction_date)
Returns the last day of the month for each value in the termination_date column.
Considerations:
For advanced users: Instead of passing a column name, you can pass a function for chained operations.
✍🏼 Empty values in your data set are stored as 1970-01-01. This means that if date fields are empty, they can be returned as negative values when used in a formula in Abacum.
To learn more about it, please visit this Abacum Academy article.