So I have a "gazillion" dates in my "Date" Column
01/01/09
I wanted to extract the year and month, so isued the =year[x] and =month[x] fx and then concatenanted the 2 =year[x]&month[x].
This doesn't allow for proper sorting
when I sort I get the following
20091
200910
200911
200912
20092
ect
to work around this issue I used the followin f(x)
MONTH1: IIf(Len(Month([c-date]))=1,0 & Month([c-date]),Month([c-date]))
200901
200902
200903
200904
(...)
200910
200911
200912
This fixed my issue, but was wondering is there was a more efficient solution?