How to change the date values

[#1]

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

[MayilVahanan]

HI

Try like this

SetDateYear (DateField, '2008')

Hope it helps

[#3]

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

[MayilVahanan]

Hi

     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;

[#5]

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

[#6]

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.

[#7]

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

[#8]

It is very helpful

Thanks Recardo

Regard,

Ramesh