[RESOLVED] DateAdd: Crossing Midnight

[rjbudz]

Can anyone explain why this happens and how to get around it:

This code:

DateAdd("s", 1, #12:59:59 PM#)

Returns this:
1:00:00 PM

Not this:
00:00:00 AM