how to substract from getdate()

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sergiy SSC Guru Points: 110209 More actions · Answer 1

= getdate() - 1

_____________
Code for TallyGenerator

philcart SSC-Forever Points: 47797 More actions · Answer 2

... or just to be different

DateAdd(hh, -24, GetDate())

--------------------
Colt 45 - the original point and click interface

David Burrows SSC Guru Points: 65144 More actions · Answer 3

Or

DateAdd(minute, -1440, GetDate())

OK, only kidding

Far away is close at hand in the images of elsewhere.
Anon.