Skip to main content

Just wanted to check before I put something in place to handle it. Is there anything in either the Date/Time Functions or Date Time Converter that allows you to specify that 1 year on from the 29 February 2020 is the 1st March 2021 rather than the 28 February 2021?

@ebygomm​ It seems pretty common that one year from 29 February 2020 is 28 February 2021. So think you'd have to make an exception for leap years and add an extra day if you need the next year to start at 1st March 2021 instead. If you calculate the interval between 29 February 2020 & 1st March 2021 it gives you P1Y1D


Reply