Your "today()" needs to be "CreateODBCDateTime(Now())"
Precia
----- Original Message -----
From: "Javier Flores" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, May 23, 2005 4:15 PM
Subject: Date Compare
Hi everyone!
I'm currently making a date comparation in a DBs...
SELECT cat, promo, date1, date2
FROM promo
WHERE date2 > today()
I just want to show all the the future promos, so... Any idea?
Javier
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
