hi together,

i like to monitor the job data (ttaad500).
i'll get the creation time from the table ttaad500 and then i'll write in a temp file.

but when i use the function date.to.inputstr$ i get nothing!!
I think the creation time is also in this field. I have looked in the table information.

Has everbody an idea??

thanks Olli

my code


select ttaad500.indt:creation_date
from ttaad500

cdate = date.to.inputstr$(creation_date, "%D002,3", 8 )
message(cdate)

ttaad500.indt is in utc format and you have to use something like utc.to.inputstr$ to convert the date.