1
NextVal
How can I find the next value in a date field? I want to update a field called VERSION, based on the date an item was approved OR based on its APPROVDATE. The record would look like this: ITEM APPOVDATE VERSION 783 3/25/2008 1.01 783 4/26/2008 1.02 783 4/26/2008 1.02 783 5/17/2008 1.03 783 5/17/2008 [...]
Answer Question
| September 12, 2008 1:10 PM
APPROVDATE, NEXTVAL
How can I find the next value in a date field? I want to update a field called VERSION, based on the date an item was approved OR based on its APPROVDATE. The record would look like this: ITEM APPOVDATE VERSION 783 3/25/2008 1.01 783 4/26/2008 1.02 783 4/26/2008 1.02 783 5/17/2008 1.03 783 5/17/2008 [...]
Answer Question
| September 12, 2008 1:10 PM
APPROVDATE, NEXTVAL
1
