Fun with Dates

[Darren_Murphy]

@Jeff_Hager

There is some stuff somewhere on here regarding ordinal dates, which might work for doing this. Unless I think of something simpler.

Guilty as charged

Find the last day of the following month

@Jeff_Hager how would you calculate the Ordinal Date using Glide math? (I know I could do it with my usual brute force approach, but…)

@Robert_Petitto I think that ordinal date formula will work for your use case, yeah? Just convert all your dates to ordinals, then you can do a direct numerical comparison.