Current date as a Parameter

[suja.somu]

Can we supply current date ( todays date) as a parameter in a Parallel job.
Can I do this in Sequencer.
What are the ways to do this ?

[ray.wurlod]

1. No.
2. Not in a Sequencer, but yes in a Sequence.

My preferred formula in an expression in a Sequence is to use the @DATE and @TIME system variables, but you could use Date() and Time() functions instead. Assuming that you don't want fractional seconds, a suitable formulation is

Code: Select all

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

or

Code: Select all

Oconv(Date(),"D-YMD[4,2,2]") : " " : Oconv(Time(), "MTS")

The difference is that the system variables are set when the Sequence starts; Date() and Time() reflect "now".

[BI-RMA]

And - of course - CurrentDate() and CurrentTime() (--> now) are always available as a Transformer-function in a parallel job. So they do not necessarily have to be passed to the job as a parameter.

It depends on what you need: Start-time of the job, start time of the sequence calling the job or the exact time an operation is performed within the job (for example an insert to a database).