The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi, I’m creating a running list of records (in this case, social media posts) and I’ve organized them by year, then by month, and then by week. To do this, I assigned format specifiers to each date with formulas. For example, 2019 is “2019”, January ...
Ah, you’re right @Jeremy_Oglesby, I tried without zero-padding and it worked.
And I think that solves my issue, thank you very much @Jeremy_Oglesby and @drassi, you’ve been extremely helpful.
Thanks so much @drassi and @Jeremy_Oglesby! This is exactly what I needed. Everything is grouped and displaying correctly now.
One last question, do you know of a way to display the ISOMonth name as # MonthName or just MonthName? For example, “1 Jan...
Thanks! Appreciate you thinking through this. However, any chance you’d know how to work through the error I’m receiving now?
For reference, I’ve changed the names of my Year and Week fields to correspond to what you have. Here are their formulas cu...
Hey, thanks so much for your input, @drassi! I was looking up ISO information on months and saw that same thing; where months are not standardized or defined.
If I could compute every day in a year (DDD) as a number (For example, January 1 = 1, Decem...
Hey, thanks for your response. This almost got me where I’d like the table to be, but there are a few hiccups. After changing the “Year” column to Week year (ISO) and “Week #” column to Week of the year (ISO), 12/29/2019 was added to the appropriate ...