select volume_name, pending_date, pending_date+(7 days) from volumes
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, August 01, 2003 11:49 AM
To: [EMAIL PROTECTED]
Subject: Adding days to a date.
Importance: Low
Dear All,
I am currently trying to write a script on a TSM server 4.2, but have
come across a problem.
I am receiving a PENDING_DATE to which I need to add, say one week, 7 days.
If I type in display
PENDING_DATE + 7 DAYS or anything similar it gives an error. Does anybody
have a way around
this, or am I stuck with adding the 7 days manually in a spreadsheet.
Many Thanks,
Andrew Young
DSG / ICT
1st Floor
Co-Operative Insurance Society,
Miller Street,
Manchester,
M60 0AL.
Tel: 0161 837 5079
Fax: 0161 837 4600
e-mail: [EMAIL PROTECTED]
*************************************************************************
This e-mail may contain confidential information or be privileged. It is intended to
be read and used only by the named recipient(s). If you are not the intended
recipient(s) please notify us immediately so that we can make arrangements for its
return: you should not disclose the contents of this e-mail to any other person, or
take any copies. Unless stated otherwise by an authorised individual, nothing
contained in this e-mail is intended to create binding legal obligations between us
and opinions expressed are those of the individual author.
The CIS marketing group, which is regulated for Investment Business by the Financial
Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life
assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 - for unit
trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for
ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686
Internet http://www.cis.co.uk E-mail [EMAIL PROTECTED]
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank
p.l.c., registered in England and Wales number 990937, P.O. Box 101, 1 Balloon Street,
Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of
the Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
