Date format changing to numbers

[evansabres]

Hello -

I have a data file that has a date field in the format MMM-DD-YYYY.

I have in my script some language to pull the parts of the date I want for my application:

Mid([Line item start date],4,3) AS adSRTmnth,
Mid([Line item start date],8,4) AS adSRTyear,

For whatever reason, the months and years appear as numbers as opposed to the words.

Any thoughts / suggestions?

Thank you.

[maximiliano_vel]

Try

Month(Date#([Line item start date], 'MMM-DD-YYYY')) as adSRTmnth,

Year(Date#([Line item start date], 'MMM-DD-YYYY')) as adSRTyear,

[Clever_Anjos · Accepted solution]

If you´re using a date field, it´s better to use date functions

Month([Line item start date]) AS adSRTmnth,

Year([Line item start date]) AS adSRTyear,

[evansabres]

this works in the scripting, but does not produce any results. When I type in the 'MMM-DD-YYYY' the text remains black, am I doing something incorrectly?