did this ever work for you? why should it? Dates are not integers. Did you
mean one day, one month, one week, one year less? How is it supposed to
know.
why arent you using the real function dateAdd(day,-1,getdate())?
-----Original Message-----
From: webmaster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 5:24 PM
To: Fusebox
Subject: SQL SERVER 2000 GETDATE() -1
I hope someone out there can help me.
I'm polling my sql server 2k database for data according to the date it
was submitted inside the database. This is what I am currently using in
my "where statement":
formfield <= getdate() -1
the -1 is supposed to select all data one day old using the short date
mask in the database. All values in the database are already in the
mm/dd/yyyy form.
but this is not working. Does someone out there have a solution for me?
If someone wants to see this monster fusebox site, go to
www.hotmediadeals.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
