I've been working with Ian Branch on an alternative to INTERVAL for incermenting/decrementing timestamps. I've attached two files - one is a pure SQL internal function and the other an external function written in Dedlphi.

The SQL one is DateAdd - used line DateAdd('DAY',5,TimestampValue). The big difference between DateAdd and INTERVAL is that DateAdd uses a variable not a constant.

Ian and I have tested as best we can and it seems to be working correctly. Anyone finding problems please post here.


Roy Lambert