topic Duplicate Date Format in QlikView

Duplicate Date Format

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

I have a date field,i am planing to change date format like MM-YYYY.

Not able to achieve the exact date format.I am getting duplicate date format like below.

Please find excel file for raw data.

Frank_Hartmann — Sun, 28 Oct 2018 09:38:03 GMT

Maybe like this:

LOAD  MonthName([Comparison Timestamp]) as [Comparison Timestamp],
  
FROM

(ooxml, embedded labels, table is Sheet1);

jobsonkjoseph — Sun, 28 Oct 2018 13:04:46 GMT

Hi,

is this the output you are looking for;