Handling date in a sqeuence

fadle · Post by **fadle** » Tue Feb 03, 2009 9:35 am

I have a parameter in the sequence indicating a date. This parameter is in a String format "YYYYY-MM-DD". one parallel job inside the sequence need the day before the date of this parameter. I created a parameter in the sequence to change the date that will be sent to the job, but I'm having trouble with the functions that can deal with this date in the sequence.

betterthanever · Post by **betterthanever** » Tue Feb 03, 2009 9:40 am

once the parameter is passed to the job, where do you want to calculate the previous day for that date?? in a transformer??? or in a where clause??

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Feb 03, 2009 9:46 am

IConv and OConv

samsuf2002 · Post by **samsuf2002** » Tue Feb 03, 2009 9:58 am

Sainath.Srinivasan wrote:IConv and OConv

I don't think we have Iconv()/Oconv() in parallel jobs.

fadle · Post by **fadle** » Tue Feb 03, 2009 10:04 am

once the parameter is passed to the job, it is used to read a file with CFF. The file name is name#date# where date should be the date retreived from the sequence.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Feb 03, 2009 10:27 am

The requirement is in the sequencer and not in the job.

vinothkumar · Post by **vinothkumar** » Tue Feb 03, 2009 10:32 am

Place a User Variable stage in the sequencer and do the calculations on date. Once you have calculated the previous date you can pass this value for that parallel job as job parameter

DSXchange

Handling date in a sqeuence

Handling date in a sqeuence

Re: Handling date in a sqeuence