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 ------------------------------
Report for Expired Training Records
Greetings, We are trying to create an application to store Training Records. Each Function is related to many Training Records. Each Person is related to many Training Records. People [Person Name] (also known as "Trainee" in English speak) Function [Function Name], [Revision Date] Training Record [Training Date], related [Function Name], related [Person Name] (from Person table) We are seeking to build a Report of all Training Records for which the latest Training Date (from Training Record Field for a given Trainee) is before the Revision Date from the related Function field. (If a Person was trained to the Function in 2019, again in 2020, again in 2022, and again on 4/2/2024; only the 4/2/2024 latest training date is examined per the Function Name). We don't want to display expired Training Records if there are newer (non-expired) Training Records to the same Function Name for the same Person Name. What fields/relationships/summary fields/etc. need to be set up to make this work? How do we do this? Thanks, PC