topic Re: Date format changing to numbers in QlikView

Date format changing to numbers

evansabres — Wed, 12 Aug 2015 15:50:19 GMT

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.

Re: Date format changing to numbers

maximiliano_vel — Wed, 12 Aug 2015 15:54:50 GMT

Try

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

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

Re: Date format changing to numbers

Clever_Anjos — Wed, 12 Aug 2015 15:59:23 GMT

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,

Re: Date format changing to numbers

evansabres — Wed, 12 Aug 2015 16:01:06 GMT

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?