Date arithmetic for Interactive SQL on the AS/400

[K.Forsythe]

Try date + 1 year

[Guest.Visitor]

Date arithmetic for Interactive SQL on the AS/400

Can anyone tell me how to do arithmetic with date fields using STRSQL. For example, I want to update a date field in a file for certain records. How would I add 1 year to the DATE01 field? Would it be something like: UPDATE MYLIB/FILEA SET DATE01 = DATE01 + (what goes here????) Thank You

[ukpi1b]

Date arithmetic for Interactive SQL on the AS/400

Check http://www.mcpressonline.com/mc?prin...ae.1@.6ae58825 posting. It has some examples