Hi,
I want to make a field in which the date is represented in this format, yyyy_mm, but I want to be able to sort on the field and have it list the months in order.
So far I know of the format and datepart functions, but both return a text value. Does anyone know of a way to do this that returns an integer value?
Thanks,
Andrew