Sort by date

Onlylonely

Hi All,

Hope you're doing well.

I'm facing an issue and hope to resolve this.

1st issue - try to get MMMYY from created (date). But unable to do so, so i've decided to write a formula. For example - Apr 2022 i will get 4/2022 << Resolved

2nd issue - I tried to sort by date in report, but it doesn't work. Anyone can help on this? Or have better way to solve this issue?

Paul Newcome

Try making the month 2 digits.

=IF(MONTH(Date@row)<10, "0", "") + MONTH(Date@row) + ....................................