Hey, I’m trying to list a series of calendar events grouped by month. They are sorted by the numeric value of the month (data set format looks like: 1//1/2021) -So far this works correctly, however I’d like the event’s marked as “NO DATE”, to be sorted at the top in a list of newest to oldest (so it would need to in this case be seen as the 13th “month”). Currently the expression is doing the exact opposite of what I want and NO DATE items end up at the bottom with oldest dates, and I can’t seem to locate documentation on the expression that would help me here… I was curious if anyone had a solution?
IF(ISBLANK([Event Date]),“NO DATE”,CONCATENATE(
SWITCH(
MONTH([Event Date]),
1,“January”,
2,“February”,
3,“March”,
4,“April”,
5,“May”,
6,“June”,
7,“July”,
8,“August”,
9,“September”,
10,“October”,
11,“November”,
12,“December”,
“”
),
" ",YEAR([Event Date])
))
LinkedIn
Twitter
