[SQL] DATE

[john whale]

PLEASE ADVISE HOW I SHOULD ALTER THE COMMAND:

<$NOW;DDMMMM;YYYY>

TO GIVE ME A DATE THAT IS X DAYS FORWARD

ie:  I WISH TO REPRESENT A DATE IN FORM WHICH IS A 7 DAYS FORWARD
OF THE DATE NOW.

REGARDS

JOHN WHALE