Re: SQL to increment date

["Jim Essinger" <dilbernator@xxxxxxxxx>]

Alan,

I did not know you had added the ConverToidate function in your UDF.  I
re-downloaded the utility and updated.  Thanks for your contribution.  I use
it all the time, and recommend it highly!

Jim

On Dec 20, 2007 11:13 AM, Alan Campin <Alan.Campin@xxxxxxxxxxxxxxxx> wrote:

> <snip>
> Iam looking for an SQL to increment   date by one day.
>  update ABC36f/FILE set PDATE = pdate+1 where the Pdate= 2007/12/19.
>
>  PDATE is defined as 9decimal. Can some one advise me how to do work
> this out?
> </snip>
>
> You will find my UDF iDate at www.think400.dk/downloads.htm so to do
> what you want.
>
> Update ABC35F/FILE Set PDATE = ConvertToiDate(iDate(PDate,'*CCYMD') + 1
> Days),'*CCYMD')
>
> Other alternative is to do what Elvis suggested and convert to date data
> type manually.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.