topic Re: need to change date formate in QlikView

need to change date formate

yadav_anil782 — Thu, 24 Sep 2015 06:21:51 GMT

Dear All,

i have date in month-year format like (march-2015) but i want to change this format in 1-march-2015 , so plz help if any body can help .

Apr-13

Apr-14

Apr-15

Aug-10

Aug-11

Aug-12

Aug-13

Aug-14

Aug-15

Dec-10

Dec-11

Dec-12

Dec-13

Dec-14

Feb-11

Feb-12

Feb-13

Feb-14

Feb-15

and want to change in-

1-Apr-13

1-Apr-14

1-Apr-15

1-Aug-10

1-Aug-11

1-Aug-12

1-Aug-13

1-Aug-14

1-Aug-15

1-Dec-10

1-Dec-11

1-Dec-12

1-Dec-13

1-Dec-14

1-Feb-11

1-Feb-12

Re: need to change date formate

petter — Thu, 24 Sep 2015 06:24:37 GMT

Load Script or in the App (GUI) in a chart?

Re: need to change date formate

tresB — Thu, 24 Sep 2015 06:26:17 GMT

Date(Date#('Apr-13', 'MMM-YY'), 'DD-MMM-YY')

Or,

Date(Date#(DateField, 'MMM-YY'), 'DD-MMM-YY')

Re: need to change date formate

petter — Thu, 24 Sep 2015 06:29:00 GMT

I presume that the Apr-13 is in a text format then it could be done like this:

=Date#( '1-' & DateField1 , 'd-MMM-YY')

or in script:

Date#( '1-' & DateField1 , 'd-MMM-YY') AS DateField2

Re: need to change date formate

prma7799 — Thu, 24 Sep 2015 06:31:58 GMT

Try...

=Date(Date#('Apr-13', 'MMM-YY'), 'DD-MMM-YY') .

Re: need to change date formate

PrashantSangle — Thu, 24 Sep 2015 06:34:54 GMT

Hi,

You can use monthstart()

try like

Monthstart(Date#(DateField, 'MMM-YY'))

Regards