topic Re: date in QlikView

date

Thu, 04 Jul 2013 11:53:00 GMT

Hi All,

I have a field which has month year ie MMMYYYY and I need to use this field and get a date as evry first of that month.

example: if the month year is Apr 2013 I need teh value as 1 Apr 2013,

jan 2013 as 1 jan 2013.

Please anybody can help.

Thanks in advance

Re: date

nilesh_gangurde — Thu, 04 Jul 2013 12:06:37 GMT

Hii,

Use the below mentioned script at load time.

Monthstart

(DAte(DATE#(Field_Name ,'MMM-YYYY'))) as New_Field_Name

Hope this will help.

-Nilesh

Re: date

AbhijitBansode — Thu, 04 Jul 2013 12:08:29 GMT

You can make use of makedate function.

May be like below:

Date(makedate (2013,04),'D-MMM-YYYY')

- second parameter to the makedate function is month number.

I will suggest you to create new column in the script (may be [Month #]) using month name field.

Re: date

Gysbert_Wassenaar — Thu, 04 Jul 2013 12:10:00 GMT

date#(MyDate,'MMMYYYY') will create dates that are the first day of the month. It's not clear from your description if your monthyear field contains a space between the month or not. Adjust the formula as needed.

Re: date

Thu, 04 Jul 2013 12:12:40 GMT

TRY THIS

=Date(Date#('Apr 2013','MMM YYYY'),'DD-MM-YYYY')

Re: date

er_mohit — Thu, 04 Jul 2013 12:20:10 GMT

tRY THIS IN TEXT OBJECT

=date( date#('01' &'Apr 2013','DDMMM YYYY'),'DD MMM YYYY')