DSXchange

Posted: **Wed Jun 02, 2010 11:13 am**

Hello,
I am using DSJobStartTimestamp in transformer. I want to minus 1 day from the time the job was started and be written to the file.

thanks

Posted: **Wed Jun 02, 2010 11:59 am**

Use TimestampFromSecondsSince

Posted: **Wed Jun 02, 2010 1:43 pm**

86400 seconds since, if I recall correctly.

Posted: **Wed Jun 02, 2010 2:02 pm**

make that column as Julianday from date and minus 1 and again revert as date from julianday, Please correct if i am wrong

subtract a day from DSJobStartTimestamp