Forum Discussion
hoyt22
Helper I
1 year agoSorting 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...
hoyt22
Helper I
1 year agoAshish_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
Super User
1 year agoSorry, i misunderstood.