How to use Date Filters in Select Editor of Data flow? -

[Russian Wyatt 2]

In Data Migrator, I have a data flow that is moving data from one table to another based on a date field. Right now I have to manually set the date field to be "greater than" a certain date.

But what I would like to do is have it pull all the data from the source as of three weeks ago. (today - 21 days).

I'm on version 9.2

Any ideas?

[David Beagan]

Could you put the following -SET statment in your server profile (edasprof.prf) to calculate a global variable with the value of the date for 3 weeks ago?

-SET &&3WeeksBack = AYMD(&DATEH8,-21,'I8YYMD');

And then use the global variable where you were using the date?