-2

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?

     --first attempt
     SELECT DateAdd("d",1,EffDate) 
     FROM pub.pv_currrates

     --another attempt does not work 
     SELECT ADD-INTERVAL(b.BillDate, days, 1) AS one_day_back
     ...

UPDATE: I found this add-interval function, but we can't seem to get it to work correctly.

2
0

I ended up figuring it out. As I am not used to this way to add dates in this RDBMS, I figure I should post this so everyone may know.

 SELECT EffDate+1
 FROM pub.pv_currrates

Not the answer you're looking for? Browse other questions tagged or ask your own question.