Forum Discussion
sraj
Responsive Resident
4 years agoMonth Day Calendar table
Hi Everyone, I created a new CALENDAR table for the below column: Month Day = FORMAT([Date],"MMM dd") & " " & IF( FORMAT([Date],"dddd") = "Sunday", FORMAT([Date],"ddd" , "" )) ...
- 4 years ago
HI sraj
Add another column with this code:
MonthDay NO. = FORMAT([Date],"MMdd")then sort your Month Day column with MonthDay NO.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
sraj
Responsive Resident
4 years agoOk, that worked..I think I understood it wrong but tried the sorting of the column with the new column you suggested and that worked. Awesome!! Thank you very much!!