Hello Yusuf,
can you please in an example (what is your Inputdata, what is the result that you want to have) specify what you want to achive? In the transformer in the expression editor you have several functions in the date group, like YearFromDate, YearFromDate, DaysInYear, DateFromDaysSince, DateOffsetByComponents to name just a view.
KR Ralf
------------------------------
Ralf Martin
Principal Consultant
Infologistix GmbH
Bregenz
------------------------------
Original Message:
Sent: Wed March 30, 2022 08:37 AM
From: Idowu Yusuf
Subject: Column Derivation by rule
Hello guys. I am pretty new to Datastage and currently have a tax to create a column that looks at the number of calendar days (120 days YTD) for a particular column and returns a corresponding year. Anyone done something similar or have a suggestion on how to do this?
------------------------------
Idowu Yusuf
------------------------------
#DataIntegration