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
