Going forward this post, I'd like to ask about my issue, that touching date and time subject.
We use a Retail Calendar (445) which is different from the regular one. The year begins in October and the first day of every month is not the real first day of this month. For example for this fiscal year (2020), November begins on Oct. 6th and ends on Nov. 2d, next year there will be a different dates.
I need to create an offset field/s calculating the differences between two points of times based on that calendar.
The calculation should be dynamic and comparing every time between the date of today and the second (past/ future/ present date).
I used many kinds of script, but no one of them works with that kind of calendar.
I have my "445 calendar" and know when every month begins and ending as well as the year, so I don't need to calculate the calendar itself.. 445 means the months will have 4,4 and 5 weeks in them, for example, October will contain 4 weeks, November - 4 weeks, December 5 weeks, Jan.- 4, Feb -4, March -5, etc. My problem is to calculate this Offset. I did it successful for the regular calendar.