Forum Discussion
josephogk
Apr 21, 2023Copper Contributor
Calculate year month day between 2 dates assuming 365 days a year and 30 days a month
Hi, I need to calculate the year month day between 2 dates assuming 365 days a year and 30 days a month (i.e. ignore leap year, ignore the fact that certain months have 30 days while others have 31 d...
HansVogelaar
Apr 21, 2023MVP
I don't understand the number of days in your examples.
2*360 days + 0*30 days after 31-Jan-20 is 20-Jan-22. That leaves 10 days to 30-Jan-20.
2*360 days + 2*30 days after 01-Feb-20 is 22-Mar-22. That leaves 9 days to 31-Mar-22.
Can you explain?