How to reduce one year from current date

praburaj · Post by **praburaj** » Thu Mar 12, 2009 2:49 am

Hi,

How to reduce one year from the current date. I already tried with DateFromDaysSince. But this logic does not work. Can anyone have other approach for this? Please help me to resolve this issue

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 12, 2009 2:57 am

What does 'one year from now' mean in simple english?
...especially for '29-02-2008'?

praburaj · Post by **praburaj** » Thu Mar 12, 2009 3:25 am

I have to calculate the date of 365 days from today's date.
It means current date - 365. How to do this in data stage?

shalini11 · Post by **shalini11** » Thu Mar 12, 2009 3:52 am

U can try this function;

YearFromDate(CurrentDate())-1

praburaj · Post by **praburaj** » Thu Mar 12, 2009 4:05 am

YearFromDate function is not working. When i compiled the job, i got error like this

Error in output column derivation expression for column Dat_BE_D in link LkOutTo_RM. Invalid conversion requested from a dfloat to a date.

deepak.hsbc · Post by **deepak.hsbc** » Thu Mar 12, 2009 4:17 am

This transformationw will give you the desired result -

((YearFromDate(link.Column)-1) :'-': link.Column[6,2] :'-': link.Column[9,2])

Where link.Column is your date field coming as an input,So If you have link.Column =2009-03-12 Then the result will be 2008-03-12

deepak.hsbc · Post by **deepak.hsbc** » Thu Mar 12, 2009 4:19 am

your error is because you are using input field as DATE and the conversion function is integer.YearFromDate return INTEGER.Change the datatype to CHAR 10

Scope · Post by **Scope** » Thu Mar 12, 2009 4:44 am

Try the below function

DateFromJulianDay(JulianDayFromDate(Link.Column) - 365)

praburaj · Post by **praburaj** » Thu Mar 12, 2009 6:30 am

Thanks to all. My problem is resolved

ray.wurlod · Post by **ray.wurlod** » Thu Mar 12, 2009 3:36 pm

shalini11 wrote:U can try this function;

YearFromDate(CurrentDate())-1

U (one of our posters) did not ask the question.

The second person personal pronoun in English is spelled "you", not "u".

Please strive for a professional standard of written English on DSXchange. Among other things it makes things easier for those of us whose first language is not English.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 12, 2009 3:38 pm

shalini11 wrote:U can try this function;

YearFromDate(CurrentDate())-1

U (one of our posters) did not ask the question.

The second person personal pronoun in English is spelled "you", not "u".

Please strive for a professional standard of written English on DSXchange. Among other things it makes things easier for those of us whose first language is not English.