Hi Sally. The only way I know how would be like this…
DATETIME_FORMAT({DELIVERY DATE},'MM') & '-' & DATETIME_FORMAT({DELIVERY DATE},'MMMM')
It appends the 2 digit month to the front in order to sort the way you want.
Hi Sally. The only way I know how would be like this…
DATETIME_FORMAT({DELIVERY DATE},'MM') & '-' & DATETIME_FORMAT({DELIVERY DATE},'MMMM')
It appends the 2 digit month to the front in order to sort the way you want.
Thank you so much! This will work fine for my purposes!
Hi Sally. The only way I know how would be like this…
DATETIME_FORMAT({DELIVERY DATE},'MM') & '-' & DATETIME_FORMAT({DELIVERY DATE},'MMMM')
It appends the 2 digit month to the front in order to sort the way you want.
This has helped me massively - thank you!