Date

[smilingjohn]

HI i have a field called date and the format is like

01/01/2016 and so on I want to convert this date like

jan-2016 and so on...

Can someone please help me on this

[antoniotiman]

Hi John,

assuming 01/01/2016 is DD/MM/YYYY

set Your Format Date variable in script

SET DateFormat='DD/MM/YYYY';    //(or MM/DD/YYYY)

MonthName('01/01/2016')   -> jan 2016

or Date('01/01/2016','MMM-YYYY')  -> jan-2016

General conversion is

Date(Date#('01/01/2016','DD/MM/YYYY'),'MMM-YYYY')  -> jan-2016

Replace 01/01/2016 with Your DateField

Regards,

Antonio

[smilingjohn]

Thanks Antonio,

PLease find my attachment i have taken your suggestion and implemented and it converted what i was needed ,

IN the QVW and Excel i have attehc ...I want to generate one more  date field here how do i do it in qlikview ????

can you please help me for this

Thanks

[antoniotiman]

Which new date field ?

Can You clarify ?

[vinieme12]

You can re-use the same fields to generate as many fields, example

LOAD Customers,

Created as Created_TimeStamp,

    MonthName(Created ) as Created,

    WeekYear(Created) as CreatedWeek,

     //Updated,

     Updated as Update_TimeStamp,

     MonthName(Updated ) as Updated,

    // Resolved,

    Resolved as Resolved_TimeStamp,

     MonthName(Resolved ) as Resolved,

    // Closed,

    Closed as Closed_TimeStamp,

     MonthName(Closed ) as Closed

FROM

(ooxml, embedded labels, table is Sheet1);