Date From and Date To in Sequence

prasson_ibm · Post by **prasson_ibm** » Thu Jul 21, 2016 4:22 am

Hi All,

I am stuck in requirement where I need to pass DATE_FROM and DATE_TO in sequence job activities where DATE_FROM is first day of previous moth and DATE_TO is last day of previous month if I am running my sequence in current month.

Can anyone help me with the date derivation logic.

Regards
Prasoon

qt_ky · Post by **qt_ky** » Thu Jul 21, 2016 7:14 am

If you want to use User Variable stage and DataStage BASIC, then I would guess you have to create a routine and call it.

Or, you could do something like what is mentioned by ArndW in this topic.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 21, 2016 4:01 pm

I'd also recommend User Variables.

Examine the Transforms in your Repository, particularly MONTH.FIRST and MONTH.LAST to get ideas about how to calculate these dates.

vamsi_4a6 · Post by **vamsi_4a6** » Fri Jul 22, 2016 7:07 am

Use your database and write the output to a file.

select trunc(sysdate,'MONTH')-1 as lastdayofpreviousmonth,trunc(trunc(sysdate,'MONTH')-1,'MONTH') as firstdayofpreviousmonth from dual

ray.wurlod · Post by **ray.wurlod** » Fri Jul 22, 2016 2:40 pm

Note that vamsi_4a6's syntax is specific for Oracle.