How to add a day at a datetime variable ?

 

Hello,

How to add a day at a datetime variable ?

My code :

datetime dtDateTest = D'2004.01.01 00:00';

datetime dtDateTestPlusOne;

dtDateTestPlusOne = dtDateTest + ??????? ;

Thanks,

Pierre2006

 

if you mean dtDateTestPlusOne is the next day

then

dtDateTestPlusOne = dtDateTest + (24*60*60) ;

24 hr a day * 60 min an hour* 60 sec in a min

 
phoenix:
if you mean dtDateTestPlusOne is the next day

then

dtDateTestPlusOne = dtDateTest + (24*60*60) ;

24 hr a day * 60 min an hour* 60 sec in a min

Thanks, it works.

Pierre2006

Reason: