
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 22, 2022 11:30 AM
Is there a date formula to calculate the 1st of the month based on a date? For example, I want to calculate 11/1/2022 for 10/15/22, 10/5,22, etc. = Wendy
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 22, 2022 02:52 PM
If you want a usable date rather than a string, you can do:
DATETIME_PARSE(DATETIME_FORMAT(DATEADD({Date}, 1, 'month'), "MM/YYYY"), "MM/YYYY")
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 22, 2022 12:56 PM
Hi @Wendy_Yelsik - do you mean the 1st of the next month? If so, you can do this:
DATETIME_FORMAT(DATEADD(Date, 1, 'month'), 'MM/01/YYYY')
(You don’t need the middle field, I just displayed this to show how it was derived)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 22, 2022 02:47 PM
perfect! Thank you. - Wendy

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 22, 2022 02:52 PM
If you want a usable date rather than a string, you can do:
DATETIME_PARSE(DATETIME_FORMAT(DATEADD({Date}, 1, 'month'), "MM/YYYY"), "MM/YYYY")
