Tuesday, May 6, 2008

Dynamic date ranges in queries

When you send recurring jobs to the batch queue, there will be cases where you’d like some of your date criteria to be dynamic to match the system date.

You can use the “d” shortcut as criteria when you enter query selections and the system will convert “d” to the system date when the batch job is executed.

You can also use “d” in ranges:
..d = From date null (1/1/1900) until today
..d, !d = From date null (1/1/1900) until yesterday

I have tested these criteria on 4.0, I’m not sure you can do this with earlier versions. But please let me know if you can.