Extract WeekEnds

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DJ5MD - 28 Jul 2006 16:18 GMT

:frown;

How can I use the ( #DayofWeek(datefield)# NEQ 1 or 7 ) on the following loop
code to remove (not display) weekends dates?

<cfloop from="#GetStartDate.StartDate#" to="#GetEndDate.EndDate#" index="i">
        <cfset variables.keyvalue = DateFormat(i, "YYYY/MM/DD")>
        <cfset structDaysTemplate["#variables.keyvalue#"] = "">
        <cfset structRooms.Days["#variables.keyvalue#"] = "#DateFormat(i, "MM/DD")#">
        <cfset structRooms.Totals["#variables.keyvalue#"] = 0>
</cfloop>

Reply to this Message

Dan Bracuk - 28 Jul 2006 16:29 GMT

The general idea is
<cfif DayofWeek(datefield) is not 1
or DayofWeek(datefield) is not 7>

Or you could be positive about the whole thing and do this
<cfif ListFind("2,3,4,5,6", DayofWeek(datefield)) is true>

Reply to this Message

DJ5MD - 28 Jul 2006 16:30 GMT

Correct Dan, but where would I but this code within my loop. I kept trying and it wasn't working correctly.

Reply to this Message

paross1 - 28 Jul 2006 16:43 GMT

[Q]The general idea is
<cfif DayofWeek(datefield) is not 1
or DayofWeek(datefield) is not 7>[/Q]

Dan, wouldnt' that be AND?

<cfif DayofWeek(datefield) is not 1 [b]AND[/b] DayofWeek(datefield) is not
7>[/Q]

Phil

Reply to this Message

DJ5MD - 28 Jul 2006 16:54 GMT

Phil,

It would be 1 OR 7, because were filtering for 2 values. If you said 1 AND 7,
it won't filter because the value (DayofWeek) for a specific Date will never be
1 AND 7. Meaning the date 10/15/2006 can never have a DayofWeek value of 1
(Sunday) and 7 (Saturday). It will be one or the other.

Hope that helps.

Reply to this Message

paross1 - 28 Jul 2006 17:06 GMT

I was thinking in terms of NOT displaying weekend dates, rather than filtering FOR them. Notice that I didn't say 1 AND 7, the statement says NOT 1 [i]AND[/i] NOT 7, which is quite different.

Phil

Reply to this Message

Dan Bracuk - 28 Jul 2006 17:31 GMT

[q][i]Originally posted by: [b][b]paross1[/b][/b][/i]
[Q]The general idea is
<cfif DayofWeek(datefield) is not 1
or DayofWeek(datefield) is not 7>[/Q]
Dan, wouldnt' that be AND?
<cfif DayofWeek(datefield) is not 1 [B]AND[/B] DayofWeek(datefield) is not
7>[/Q]
[/q]
Of course it would.

Reply to this Message

paross1 - 28 Jul 2006 18:16 GMT

OK, think about it. When using OR, if DayofWeek(datefield) is actually 7, and
it hits the first test of DayofWeek(datefield) is not 1, then the CFIF would be
TRUE and it would never perform the second test to see if DayofWeek(datefield)
is not 7. Using the NOT [i]requires[/i] that you use AND.Phil

Reply to this Message

DJ5MD - 28 Jul 2006 18:21 GMT

:grin;

Gotcha Phil, I misunderstood.

Anyway, here is the code that worked for my loop:


<cfloop from="#GetStartDate.StartDate#" to="#GetEndDate.EndDate#" index="i">
    [b][i]<cfif (dayOfWeek(i) gt 1) AND (dayOfWeek(i) lt 7)>[/i][/b]
         <cfset variables.keyvalue = DateFormat(i, "YYYY/MM/DD")>
        <cfset structDaysTemplate["#variables.keyvalue#"] = "">
        <cfset structRooms.Days["#variables.keyvalue#"] = "#DateFormat(i, "MM/DD")#">
        <cfset structRooms.Totals["#variables.keyvalue#"] = 0>
    </cfif>
</cfloop>

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / July 2006

Extract WeekEnds