Conversion

karry450 · Post by **karry450** » Mon Jun 30, 2008 12:03 am

Hi Friends,

I have a input DATE column which is in DD/MM/YYYY format and the problem is Im unable to do a conversion of

CURRENT DATE - DATE and my target colum is a number.

can anyone help me coverting this in datastage server jobs.

Thanks

chulett · Post by **chulett** » Mon Jun 30, 2008 12:24 am

What have you tried? Short answer is convert both to internal format and subtract. And as to your 'target column is a number'... of what? Difference in days? If so, then you should be fine if you do as noted.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 30, 2008 1:04 am

System variable @DATE does not require conversion, as it is already in internal format. The same is true of the Date() function. Therefore you are looking for an expression something like

Code: Select all

@DATE - Iconv(InLink.TheDate, "DDMY")