DSXchange

I am trying to extract data from a Unidata database using the Unidata stage in DataStage for a 24 month rolling period based on a period end date. I have tried the below but it does not seem to be working properly.

UTM_PERIOD_END > @DATE -24

Please clarify "not working".

@DATE is the system date that the query began executing, in internal format. So @DATE - 24 is the date 24 days before that (not 24 months).

You need a better technique, perhaps @YEAR - 2.