Page 1 of 1

Date

Posted: Tue Oct 23, 2007 1:11 pm
by pp
Is there an environment variable or any other way where we can get the current date as a parameter?

Re: Date

Posted: Tue Oct 23, 2007 1:14 pm
by mallikarjuna36
yes.

study parallel extender PDF .

in that you can find this.

Posted: Tue Oct 23, 2007 3:53 pm
by ray.wurlod
Can you be more specific about your use of the term "parameter"? Is this a job parameter, or do you simply need the current date within your job design? Either is possible, but we'd prefer to answer the correct question.

Posted: Tue Oct 23, 2007 9:36 pm
by pp
I have an input file name of which the date is a part.
An example file name is: abc102307
(102307 which is todays date.)

I know that we have date functions which we can use but that would be in the transformer. I would like to get the current date incorporated as a part of the filename before any processing starts.
So, I was thinking if we there was any environment variable which could accomplish this.

Thanks.

Posted: Tue Oct 23, 2007 9:43 pm
by ray.wurlod
You can pick up the date from the @DATE system variable when assigning the job parameter value in your job sequence. You probably want to convert this to a "human readable" format in the assignment expression, for example

Code: Select all

Oconv(@DATE,"D-YMD[4,2,2]")