Converting Month/Year to Short Month

[DefinitelyMaybe]

Hi All,

I have data coming in a table as January2021. I would like to convert this to Jan for reporting. I tried doing a left formula grabbing first 3 characters but in the report but the report shows the field names available as "Jan" and "Feb" as opposed to Month, the name I gave the field in the query. I also need to make sure the report sorts the months in proper order as well not alphabetized.



Thanks in advance for your help,

Eric

[CJ_London]

a bit more information required

1. is the field a text field or a date field?

2. what does this mean?

in the report but the report shows the field names available as "Jan" and "Feb" as opposed to Month, the name I gave the field in the query.

3. would also help know what you actually did to produce this result. It might be you are using a crosstab query or it might be your data is not normalised

4.

I also need to make sure the report sorts the months in proper order as well not alphabetized.

to do this you need a numeric value for the month 1 for Jan, 2 for Feb etc. Can't advise until you answer the other 3 questions

[ranman256]

format([datefield],"mmm")

[DefinitelyMaybe]

Hi Ajax and ranman,

I was able to get an actual date to use instead of using the month with year combined in the field then converted to number month as you suggested Ajax.

Thanks,

Eric