topic Re: Date Issue in QlikView

Date Issue

neha_shirsath — Mon, 24 Feb 2014 06:08:01 GMT

Hi Community,

I need your help.

I have attached the file in that I have Month field like April'13 but i want that in Date format like Apr 2013.

How can I convert that in date format.

Please help.

Thanks In Advance.

-Neha

SunilChauhan — Mon, 24 Feb 2014 06:24:32 GMT

left(Month,len(Month)-3)&' '& Right(Month 2) as Month in script

or use in dimension with "as Month"

hope this helps

Sokkorn — Mon, 24 Feb 2014 06:26:32 GMT

Hi Neha,

In load script, let add new field with below code

Date(Date#(Replace(YourDateField,Chr(39),'-'),'MMMM-yy'),'MMM yyyy')

AS NewDateField

Regards,

Sokkorn

hic — Mon, 24 Feb 2014 06:39:12 GMT

First, you need to define the long Month name in the environment:

SET LongMonthNames = 'January;February;March;April;May;June;July;August;September;October;November;December';

Then you can use this in your format code as MMMM. So, in the script you should have

Date#(Month,'MMMM''YY') as Month2,

HIC

mangalsk — Mon, 24 Feb 2014 06:46:18 GMT

Hello,

Try this

Date(Date#(YourDateField,'MMM'&chr(39)&'YY'),'MMM yyyy') as newDate

Mon, 24 Feb 2014 06:50:59 GMT

Hi Neha,

You can use following Code to achieve the result.

Date(Date#(Month,'MMM'&chr(39) &'YY'),'MMM YYYY') as YearMonth

-Regards,

Kiran

neha_shirsath — Mon, 24 Feb 2014 07:00:00 GMT

Hi Sunil,

I have did this. but its not useful in my application as i need it in date format and here it will give in string format.

Thanks for the reply.

-Neha