Help with AddHours Function

Help with AddHours Function

  
I'm using this function AddHours(#2011-10-12 08:00:00#, 1) and I am getting "#2011-10-12 00:00:00#".  Has anyone else had this problem where the hours are getting lost?
Hi Rebecca,
 
I've tried to replicate the problem, but in my sample, it work. Check the eSpace in attachment. 
Result: 

If it didn't solve your problem, what version of SS that are you using? Can you provide an eSpace with an example of the problem?

Regards,
Nelson Baptista
Hi Rebecca,
make sure that your variables are actually date time variables and not only date, because it seams that you are dropping the time part somewhere..

Regards,
Carlos Rocha
Thanks everyone!  One of the variables I was assigning the value to was a Date instead of a Date Time.