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