Re: Next "X" days - but SKIP the weekend....

[Les Mizzell]

What I got to work was to do a query returning the next 7 days, and then
filter the results with the "dayOfWeek" function.

<cfoutput query="myquery">
  <cfif dayOfWeek(myquery.Event_Date) NEQ 1
    and dayOfWeek(myquery.Event_Date) NEQ 7>

#MY OUTPUT STUFF#

  </cfif>
</cfoutput>

Thanks to all that replied - great help!

--
Les Mizzell
---------------------------------------
Do geeks die when exposed to sunlight?
---------------------------------------

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---