Calculate BIRTH DATE from AGE

naveed.zuber · Post by **naveed.zuber** » Thu Sep 04, 2014 4:10 am

Please help with below requirement-

Transformer stage below field needs to derive-

BIRTH DATE=CurrentDate() - AGE

Ex:AGE is 38.
BIRTH DATE is DATE field.

atulgoel · Post by **atulgoel** » Thu Sep 04, 2014 5:13 am

Try Below function in transformer in Datastage 8.5 version:

DateOffsetByComponents(%basedate%,%yearoffset%,%monthoffset%,%dayoffset%)

DateOffsetByComponents(CurrentDate(),-38,0,0)

chulett · Post by **chulett** » Thu Sep 04, 2014 7:40 am

How can you derive a birthdate from an AGE? Every day the 'birthday' will change. Birth year, perhaps.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 04, 2014 5:03 pm

Resist stupid requirements!

stuartjvnorton · Post by **stuartjvnorton** » Thu Sep 04, 2014 7:21 pm

ray.wurlod wrote:Resist stupid requirements! ...

Should be a t-shirt.

Whoever came up with this requirement needs to be... um... reminded... that you can't invent detail.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 04, 2014 9:30 pm

Favourite t-shirt ever:

Code: Select all

 ===>
CLOWNS

 <===
JOKERS

U · Post by U » Thu Sep 04, 2014 9:39 pm

Date of birth can be calculated from AGE, if and only if AGE is given in days and time of birth is known.

naveed.zuber · Post by **naveed.zuber** » Thu Sep 04, 2014 10:34 pm

Yes this is stupid requirement from Customer.
Thanks Atul for your help.

Below transformation function working for me.
DateOffsetByComponents(%basedate%,%yearoffset%,%monthoffset%,%dayoffset%)

DateOffsetByComponents(CurrentDate(),-1*INPUTFIELD,0,0)