topic Re: How to change the date values in QlikView

How to change the date values

Wed, 12 Sep 2012 15:23:34 GMT

Hi,

I have field a containing dates from Jan1st to Dec31st 1997,How to convert these

values into Jan1st to Dec31st 2008,plese send the answer,thanks in advance

Re: How to change the date values

MayilVahanan — Wed, 12 Sep 2012 15:35:38 GMT

Try like this

SetDateYear (DateField, '2008')

Hope it helps

Re: How to change the date values

Thu, 13 Sep 2012 19:05:47 GMT

Thanks mahal, but I have 1997,96,95. Year from Jan to Dec . I have to change them into

2008,07,06 Jan to Dec...please reply

Re: How to change the date values

MayilVahanan — Thu, 13 Sep 2012 19:14:27 GMT

Try like this,

Load *,if(Year(DateField) = 1997, SetDateYear (DateField, '2008'), if(Year(DateField)=1996,

SetDateYear (DateField, '2007'),SetDateYear (DateField, '2006'))) as ModifiedYear from tablename;

Re: How to change the date values

Thu, 13 Sep 2012 21:17:45 GMT

Hi rameshmca,

You can use a date function for this:

=AddYears(DateField, 11)

Let me know, if this changes if helpful for you.

Regards,

Ricardo

Re: How to change the date values

Thu, 13 Sep 2012 21:56:08 GMT

Hi Ricardo,

Thanks for your suggestion,its working , but I didnot understood what is meaning of 11 in the function, with the use of 11 how its changing years can you explain in detail.

Re: How to change the date values

Fri, 14 Sep 2012 01:58:27 GMT

2008 - 1997 = 11 years of difference

AddYears( <Name of the date field>, <# of years you want to add> )

AddYears('01/01/1997', 11) = '01/01/2008'

Thanks,

Ricardo

Re: How to change the date values

Fri, 14 Sep 2012 16:11:09 GMT

It is very helpful

Thanks Recardo

Regard,

Ramesh