I solved this tricky little problem by extracting just the day().

Thanks for everyone's help!