Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0O4DS033913
	for <pgsql-sql@postgresql.org>; Tue, 23 Jan 2001 23:13:28 -0500 (EST)
	(envelope-from pgsql-sql-owner@postgresql.org)
Received: from www.worldzone.co.uk ([212.90.32.125])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0MHTT051093
	for <pgsql-sql@postgreSQL.org>; Mon, 22 Jan 2001 12:29:42 -0500 (EST)
	(envelope-from john.whale@ukdirect.org)
Received: from ukmail.ukdirect.org (smtp.ukdirect.org [212.90.35.21])
	by www.worldzone.co.uk (8.9.3/8.9.3) with ESMTP id RAA14220
	for <pgsql-sql@postgreSQL.org>; Mon, 22 Jan 2001 17:30:25 GMT
Received: by UKMAIL with Internet Mail Service (5.5.2650.21)
	id <CWH5RRTA>; Mon, 22 Jan 2001 17:29:56 -0000
Message-ID: <07EB26C562C6D411ACE900C04FA33F8F5438@UKMAIL>
From: john whale <john.whale@ukdirect.org>
To: "'pgsql-sql@postgreSQL.org'" <pgsql-sql@postgreSQL.org>
Subject: DATE
Date: Mon, 22 Jan 2001 17:29:49 -0000
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2650.21)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Archive-Number: 200101/305
X-Sequence-Number: 974

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