DSXchange

Problem Solved .. Thanks for help =]

I know little about Datastage basic and
I can't find any function for dateadd
i have tried
Iconv(TimeDate(),"D") -3600
or
TimeDate() -3600
result is not correct

i dont know the function to perform the dateadd ..
i can get the date by @DATE
but i find no solution to get the date of (@Date - 1 hour )

I define a User Variables Activity and wanted to make 4 parameter base on the system datetime - 1 hour
year int
month int
day int
hour int
Is there any function i can use ?

AviETL wrote:No, actually I have admin permissions on server.

i have encountered the same problem in DataStage 8.5 .Did anyone know how to slove it