Skip to Content
0

Date generation transform error.

Nov 22, 2016 at 05:30 AM

74

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Arun Sasi Nov 22, 2016 at 09:50 AM
0

Try

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

print($Todays_date);

Result of Date Generation

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Nov 22, 2016 at 09:51 AM
0

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


print($Todays_date);

Result of Date Generation

Regards

Arun Sasi


ffxvp.png (541 B)
t00jo.png (4.3 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Arun Sasi Nov 22, 2016 at 10:50 AM
0

Screenshot was not posted earlier in my reply

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

Regards

Arun Sasi


6kx9m.png (2.9 kB)
tiby4.png (2.9 kB)
Share
10 |10000 characters needed characters left characters exceeded