Date Calculation

lthomas

How do I write a calculation to return the same date but for next month? For example, if the date showing is December 4, 2024, how do I return January 4, 2024?

Data_Devon

I'd use the AddDate() function like so:

ADDDATE('2024-12-04', INTERVAL 1 MONTH)

If you intend to also jump to the next year - i.e. from December 2024 to January 2025 - that will be an extra step.

You can also use the canned "Date Operations" tile in Magic ETL if you want to do it upstream:

Data_Devon

I'd use the AddDate() function like so:

ADDDATE('2024-12-04', INTERVAL 1 MONTH)

If you intend to also jump to the next year - i.e. from December 2024 to January 2025 - that will be an extra step.

You can also use the canned "Date Operations" tile in Magic ETL if you want to do it upstream:

lthomas

Thank you!!!

ArborRose

Just for clarity, what @Data_Devon is referencing is your field name, not a static value.

DATE_ADD(`your_date_field`, INTERVAL 1 MONTH)