date checking

[EJRoufs]

DataStage version 7.1

I am reading in a TimeStamp field, and in the Transform Stage need to check the date portion to see if it is more than 6 days old. I am going thru DataStage help to find out how to do this, but it hasn't been all that "helpful" so far. I'm going to keep trying that route, but thought I'd throw a question out here as well. I thought it's probably fairly easy to do once you do it once or twice, so was hoping maybe one of you might have a real quick and easy solution for me.

Thanks for any help! :>

[pisania]

Take a look at OCONV and ICONV functions and use @DATE variable for system date.