Dates Table to classify a given date multiple ways with additional special "Broadcast Calendar" need
Hello everyone! New user, first post. I'm looking for help in building a table where each record will represent a unique date and additional fields will equate each of those dates to a Quarter, Fiscal Year, Actual Year, etc... I think I can get most of that done on my own, however, I'd like a field to equate that specific date to a week of a Broadcast Calendar. For anyone not familiar, the Broadcast Calendar works like this (via wikipedia, main points below), Every week in the broadcast calendar starts on a Monday and ends on a Sunday. The key link between the broadcast and Gregorian calendars is that the first week of every broadcast month always contains the Gregorian calendar first of the month.For example, if January 1 falls on a Saturday, then the broadcast calendar year would begin on the preceding Monday, December 27. Days and weeks in a broadcast calendar are often referred to by number rather than name, as in Week 47, Day 3. I'd like to create a formula field that equates the day to the broadcast calendar equivalent of Year 2020, Week 47, Day3. This is not going to make or break my app and I'm in no rush, I just thought this was an interesting use-case that I should learn from. Thanks in advance for any help you can provide. ------------------------------ -- Mike Freyder ------------------------------