topic Re: Date Convert issue in QlikView

Date Convert issue

mightyqlikers — Thu, 07 Jul 2016 09:01:49 GMT

hi all,

please find the attached ,

i have date field from which i have to extract yearmonth as MMM-YYYY.

when i do date convert it is giving multiples like Apr-2016 and May-2016...

i dont want duplicate values in year month.

help is appreciated.

Re: Date Convert issue

Chanty4u — Thu, 07 Jul 2016 09:09:24 GMT

you have only one year 2016... so ur getting that lik dat try to add 2015 yr data sampple and chk it out

LOAD

date#(date(ISSUEDATE,'DD-MM-YYYY') )as ISSUEDATE,

date#(date(ISSUEDATE,'MMM-YYYY')) as ISSUEDATEYRMON

FROM IssueDT.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Date Convert issue

hic — Thu, 07 Jul 2016 09:15:34 GMT

Using the date function this way will hide the date, but the numeric part of the field will still have this information. You need to "round" it to the proper month using

Date(MonthStart(ISSUEDATE), 'MMM-YYYY') as ISSUEDATEYRMON

HIC