09-27-2017 09:26 AM - edited 09-27-2017 09:27 AM
This time, I would like to use loop transformation to pass a date9. value to another job.
In the picture,
date_from and date_to are date 9. format.
As I know, all date format are regarded as integer.
Therefore, when I set the parameter (date_from) in another job. it is also integer.
when I type %put &date_from, it gives me 20636, which is not 01JUL2016.
So what can I set to get back the value with date9. format.
i.e, %put &date_from --> 01JUL2016
09-27-2017 10:46 AM
Well, 20636 is actually 01Jul 2016. It's just not formatted.
What does the logic look like that will act on this parameter?
09-27-2017 03:20 PM
09-27-2017 10:55 PM
I have changed to character format but error obtained after entering the loop transformation
ERROR: Invalid date/time/datetime constant "20636"d.
Below is before entering the loop transformation:
If I change back to numeric type
It becomes normal
09-27-2017 11:57 PM