Help with transforming the end date of a month
Options
Alfredo Chelminski
Member ✭
If I'm working with the last days of the month, say January 31, for example, and want to now get the next last day of the month, my approach has been to use the transform_timestamp filter, and use +1 month.
The problem is that this returns March 3rd, not February 28 as I would have expected (and need).
How would I solve this, what can I do to get the last day of the next month, regardless of how many days the month has ??
The problem is that this returns March 3rd, not February 28 as I would have expected (and need).
How would I solve this, what can I do to get the last day of the next month, regardless of how many days the month has ??
Comments
-
I would use the relative time phrase "last day of next month"
https://www.php.net/manual/en/datetime.formats.relative.php#:~:text=last day of next month -
Thanks a lot!
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback