Date generation transform error.

[rajan_burad]

Hello,

I am facing a problem using global variable. I declared a global variable as $Todays_date and passed a value ‘2016.10.21’ to it. Also in script I wrote: -

$Todays_date = to_date(‘2016.10.21’,’yyyymmdd’);

Print = ($Todays_date);

In date generation transform I passed the start date value as $Todays_date.

When I ran the job it says start date cannot be less than end date. When I modified the job data starting from ‘1900.01.01’ till end date is getting printed.

But I want to load the data from 2016.10.21 to 2016.11.21.

I am able to do it successfully only when I declare the values of start and end date in data generation options.

Please help.

Thanks,

Rajan

[former_member198401]

Screenshot was not posted earlier in my reply

You can use another variable in End Date as per your requirement

Regards

Arun Sasi

[former_member198401]

$Todays_date = add_months( sysdate(),-1);

print($Todays_date);

Result of Date Generation

Regards

Arun Sasi

[rajan_burad]

So in this $Todays_date variable is passed in End_date option, right?

[former_member198401]

Try

$Todays_date = add_months( sysdate(),-1);

print($Todays_date);

Result of Date Generation

Regards

Arun Sasi