Date and Time picker time addition

justincswork · 2023-02-08T03:35:30.769Z

Hello,

I am applying a formula to my date and time picker to show the next date that an item price will be valid till, which is 6 months from the current date, but I need it to show the end of the month.

For example - I have a valid from date picker and a valid till date picker. I am adding 6 months to each one, but it adds exactly 6 months. So 6 months from the 30th of Sept, becomes the 30th of March, but there are 31 days in March so I am needing to show that. How do i construct a condition or formula to make this happen? Currently my formula has ‘+ month 6’ on the end of it. Any help would be appreciated.