Forum Discussion
hoyt22
Helper I
Helper ISorting a Date Table with Broadcast Dates
Hi all, I work in media, so I have a date table with calendar time periods and broadcast time periods. I believe everything is set up correctly to figure out broadcast year, quarter, month, and w...
Ashish_Mathur
Super User
Super UserHi,
In the Date Table, change the data type of the Broadcast day column as Whole number.
hoyt22Helper I
Helper IAshish_Mathur Thank you, but unfortunately, that doesn't solve my problem. Your solution sorts the broadcast days numerically, but that's not exactly what I need.
Here's what your solution did:
But the 29 is January 29, so it should be listed first. The correct order should be 29, 30, 31, 1, 2, 3, 4. That's because the Broadcast Week of January 29 contains the dates: January 29-31 and February 1-4.
- Ashish_Mathur
Sorry, i misunderstood.