I am looking for a similar way to add a day to a date value in progress DB the same way you would in SQL server?
SELECT DateAdd("d",1,EffDate) FROM pub.pv_currrates
UPDATE: I found this add-interval function, but we can’t seem to get it to work correctly.