topic Re: date 11 jan 2011 in QlikView

date 11 jan 2011

Wed, 25 Jun 2014 10:24:28 GMT

in my date field 11 jan 2011

how to retrive the month ,date year

tresB — Wed, 25 Jun 2014 10:26:19 GMT

Date(Date#(YourField, 'DD MMM YYYY')) as Date

Month(Date#(YourField, 'DD MMM YYYY')) as Month

Year(Date#(YourField, 'DD MMM YYYY')) as Year

Anonymous — Wed, 25 Jun 2014 10:26:45 GMT

Hi,

Try below,

Date(Date#('11 jan 2011', 'DD MMM YYYY')) as Date,

Day(Date#('11 jan 2011', 'DD MMM YYYY')) as Day,

Month(Date#('11 jan 2011', 'DD MMM YYYY')) as Month,

Year(Date#('11 jan 2011', 'DD MMM YYYY')) as Year

Wed, 25 Jun 2014 10:37:34 GMT

these are not working

its_anandrjs — Wed, 25 Jun 2014 10:37:53 GMT

Try like below scripts what is your date format.

Date(Date#(YourDateField, 'DD MMM YYYY'),'DD/MM/YYYY') as Date

//For Date use below scripts

MakeDate(Year(Date#(Right('11 jan 2011',4),'YYYY')), Month(Date#(mid(Da,4,3),'MMM')),Day(Date#(Left('11 jan 2011',2),'DD'))) as DateField

Month(Date#(YourDateField, 'DD MMM YYYY')) as Month

Month(Date#(mid('11 jan 2011',4,3),'MMM'))

Year(Date#(YourField, 'DD MMM YYYY')) as Year

Year(Date#(Right('11 jan 2011',4),'YYYY'))

alexandros17 — Wed, 25 Jun 2014 10:39:51 GMT

Try simply these

Month(YourField) as Month

Year(YourField) as Year

Let me know