Hello,
I made a little vacancy project I tested the function on random dates everything was perfect. unfortunately, I never thought it will calculate differently with those 04 months
(March, April, May, July)
please notice that date formatting: YYYY/mm/dd
MonthsBetween(2021/01/01,2021/12/31) ------------> 11
MonthsBetween(2021/02/01,2021/12/31) ------------> 10
MonthsBetween(2021/03/01,2021/12/31) ------------>
10 expected to be 09MonthsBetween(2021/04/01,2021/12/31) ------------>
09 expected to be 08MonthsBetween(2021/05/01,2021/12/31) ------------>
08 expected to be 07MonthsBetween(2021/06/01,2021/12/31) ------------> 06
MonthsBetween(2021/07/01,2021/12/31) ------------>
06 expected to be 05MonthsBetween(2021/08/01,2021/12/31) ------------> 04
MonthsBetween(2021/09/01,2021/12/31) ------------> 03
MonthsBetween(2021/10/01,2021/12/31) ------------> 02
MonthsBetween(2021/11/01,2021/12/31) ------------> 01
MonthsBetween(2021/12/01,2021/12/31) ------------> 00
I already printed all the Holiday statements for the employees I made a huge mess my boss is so angry
unlike some of my coworkers
So what's wrong, is that normal and exactly how it suppose to work ?