3 years ago
MONTH_FIRST_DAY
What's new?
MONTH_FIRST_DAY is a function that calculates the first 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_FIRST_DAY (transaction_date)
Unifies the dates in the transaction_date column to return the first day of each month.
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.