Thanks! It work
JJ -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Joe Kelly Enviado el: Lunes, 23 de Mayo de 2005 05:11 p.m. Para: [email protected] Asunto: Re: Date Compare Here's some old 4.5 code. It works. <cfquery name="Calendar" datasource="#dbName#" dbtype="ODBC"> SELECT * FROM CALENDAR ORDER BY DATE_START, TIME_START </cfquery> <cfset Today=DateFormat(Now(),"m/d/yy")> <cfoutput query="Calendar"> <cfset Comparison = DateCompare(#DateFormat(DATE_START, "m/d/yy")#, #Today#)> <cfif Comparison GTE "0"> <tr> <td>#DateFormat(DATE_START, "m/d/yy")#</td> <td><b>#TEAM#</b></td> <td>#LOCATION#</td> <td>#TimeFormat(TIME_START, "h:mmtt")#</td> </tr> </cfif> </cfoutput> Good Luck Joe Kelly On 5/23/05, Vance Duke <[EMAIL PROTECTED]> wrote: > You can use the SQL function "getdate()" This will give you the exact date > and time of the call and show anything in the future. > > > SELECT cat, promo, date1, date2 > > FROM promo > > WHERE date2 > getdate() > > > ----- Original Message ----- > From: "Javier Flores" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Monday, May 23, 2005 3: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 > > > ---------------------------------------------------------- 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
