I am creating a rotating seasonal calendar for gardening where year is not needed. For some reason, some of the years started showing up as 2026 and others are showing up as 2025. This has totally screwed up all my logic for if/then columns based on if one date is before or after another date. I have spent months setting this up and was just about to launch and now the whole damn thing is broken because the years are all messed up now for some reason. Why isn’t there a simple option to format without years? Any ways to fix this so all the years are consistent and have them all change to the same year at the change of a new year?
Do you have screenshots? Not really following what you are explaining. A Date type column is always going to include a year (as well as time). Otherwise it’s not a valid date. If you are just inputting a month and day, it’s most likely rounding to the nearest year. Regardless, some simple math could extract just Month and Day if that’s all you need. Likewise, if you just store a number that represents month and day in a numeric type column, then you could run comparisons as a number. It would be helpful to have better context though to provide the best solution, especially how you are using those dates.
1 Like
I followed up your post here and tried to type dates into a Date column:
Jan 5 => Jan 5, 2026
Feb 5 => Feb 5, 2026
Mar 5 => Mar 5, 2026
Then every month afterwards resolves to 2025
Apr 5 => Apr 5, 2025
…
Dec 5 => Dec 5, 2025
So it looks like the rounding effect is correct here, assuming OP was typing like me. When you type a date without year like Jan 1, Glide evaluates whether Jan 1, 2025 or Jan 1, 2026 is closer to the current date and resolves to that one.
In this case, 2026 wins.
In this case, 2025 wins.
1 Like