topic Convert Month in Script in QlikView

Convert Month in Script

evansabres — Thu, 16 Feb 2017 21:32:02 GMT

I have a field called [Event Date Time] which is formatted as MM/DD/YYYY and is numeric so, 11/12/2016

I want to display just the MM (months) in a list box. In the script, how can I pull out just the month and convert it to just display NOV for the above date.

Re: Convert Month in Script

aarkay29 — Thu, 16 Feb 2017 21:35:43 GMT

Date([Event Date Time],'MMM')

Re: Convert Month in Script

evansabres — Thu, 16 Feb 2017 21:40:22 GMT

When I enter this in my script I get errors and I cannot reload. Am I missing something other than

MONTH([Event Date Time], 'MMM') ??

Re: Convert Month in Script

vishsaggi — Thu, 16 Feb 2017 21:59:24 GMT

Try this?

Month([Event Date Time]) AS Month

Month takes only one parameter...

Re: Convert Month in Script

Thu, 16 Feb 2017 22:02:38 GMT

Hi Evan,,

Use the below script and use the Month field in the list box

Test:

LOAD

"[Event Date Time]",

month("[Event Date Time]") as Month

FROM

********** source.

Re: Convert Month in Script

MarcoWedel — Thu, 16 Feb 2017 22:19:24 GMT

If your [Event Date Time] field is not a dual value already, then you can try with

Month(Date#([Event Date Time],'MM/DD/YYYY'))

else this expression should be sufficient:

Month([Event Date Time])

hope this helps

regards

Marco

Re: Convert Month in Script

Fri, 17 Feb 2017 03:30:48 GMT

!Hi,

The first thing you have to do is, to say what is the format of the date in date# function.

And you can use the date function to tell how the data should be shown.

While using Month(date()), the output will be your expected format 'Nov'.

You can use the following function.

load

month(date(Date#([Event Date Time],'MM/DD/YYYY'))) as [Event Date Time]

from source_table_name;

Attached qvw for your reference.

Regards,

Vivek

Re: Convert Month in Script

Chanty4u — Fri, 17 Feb 2017 05:46:20 GMT

try below script

LOAD * INLINE [

"Event Date Time"

11/12/2016

12/12/2016

13/11/2016

14/12/2016

];

Result:

LOAD

Month( "Event Date Time") as NewMonth

Resident a;

Re: Convert Month in Script

sdmech81 — Fri, 17 Feb 2017 05:51:37 GMT

HI just say,

month( [Event Date Time]) as Event Date Time]

It ll give u month name as NOV

Sachin