topic Re: date format issue,request help in QlikView

date format issue,request help

Mon, 08 Sep 2014 06:53:19 GMT

hi,

I have a field in the below format.I need to extract the following dates as only monthnames.How could I do please can someone help me out??

eg:1/1/2014 12:00:00 AM= January

2/1/2014 12:00:00 AM =February etc

fieldA

1/1/2014 12:00:00 AM

2/1/2014 12:00:00 AM

3/1/2014 12:00:00 AM

4/1/2014 9:51:48 AM

1/1/2015 12:00:00 AM

2/1/2015 12:00:00 AM

3/1/201512:00:00 AM

4/1/2015 9:51:48 AM

.......

regards,

Sahana

Re: date format issue,request help

sushil353 — Mon, 08 Sep 2014 06:56:15 GMT

Hi ,

Try this:

Date(Date#(fieldA,'DD/MM/YYYY hh:mm:ss TT'),'MMMM')

HTH

Sushil

Re: date format issue,request help

PrashantSangle — Mon, 08 Sep 2014 06:59:13 GMT

Hi ,

Try this:

Date(Date#(fieldA,'MM/DD/YYYY hh:mm:ss TT'),'MMMM')

Regards

Re: date format issue,request help

Mon, 08 Sep 2014 07:03:43 GMT

Hi ,

you need to add the below condition into your script

Date(Date#(fieldA,'DD/MM/YYYY hh:mm:ss TT')'MMMM') as MonthName

Regards

Charitha

Re: date format issue,request help

senpradip007 — Mon, 08 Sep 2014 07:04:59 GMT

You can use:

Date(fieldA, 'MMMM')

Re: date format issue,request help

sushil353 — Mon, 08 Sep 2014 07:07:23 GMT

There is one another way:

Edit your initial variables with full month name

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

And then simply use:

Month(fieldA)

HTH

Sushil

Re: date format issue,request help

Mon, 08 Sep 2014 07:07:55 GMT

Hi,

Try conversion using this code DATE(DATE#(SUBFIELD(FieldA,' ',1),'MM/DD/YYYY'),'MMM')

Re: date format issue,request help

Mon, 08 Sep 2014 07:09:40 GMT

yes , if you have all the data is in the same format (dd/mm/yyyy) then no need to use date#, directly we can apply date() on specific otherwise need to convert the date into same format of all values.

-Charitha

Re: date format issue,request help

senpradip007 — Mon, 08 Sep 2014 07:19:30 GMT

Hi Lakshmi,

As Sahana did not mention that the date can be in dual format, I'm using only date(). Otherwise date# will come into play.

-PS