Wrong list. InterBase general support questions do not belong here.
Please use the IB-Support list here on the same yahoo groups area.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <hans@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, August 09, 2001 3:17 PM
Subject: [IBO] Date Question


> Help,
>
> I'm drawing a blank in Server SQL
>
> Declare Variable OldDate Date;
> Declare Variable NewDate Date;
>
> Declare Variable yy Integer;
> Declare Variable mm Integer;
> Declare Variable dd Integer;
>
> yy = Extract(Year from OldDate);
> mm = Extract(Month from OldDate);
> dd = Extract(Day from OldDate);
>
> yy = yy + 1;
>
> NewDate = PutBackToGether (yy,mm,dd);
>
> What do I use for PutBackToGerher (yy,mm,dd) to get NewDate ??
>
> Best Regards
> Hans