Date Convert issue

[mightyqlikers]

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.

[Chanty4u]

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);

[hic · Accepted solution]

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