| Posted By |
Discussion Topic: Adding days
|
|
riogrande |
06-27-2012 @ 8:33 AM |
|
|
Senior Member
Posts: 509
Joined: Mar 2003
|
Hi all
I am querying the table which contains a list of holiday dates. I set a variable called meetingdate that in production will be a form variable at the moment I have hardcoded a date in the table.
The code should add days to the date according to the dayofweek.
When I output meetingdate it shows the variable 2012-07-02 and has the correct day of week (2- monday) but it doesn't add any days. how can I make it work? Thank you!
<CFQUERY name="hols" datasource="salesdb">
SELECT * FROM holidays
</CFQUERY>
<cfset meetingDate = '2012-07-02'>
<cfif ListFind(ValueList(hols.holiday), hols.holiday)>
<cfif DayOfWeek(meetingDate) eq 2>
<cfset meetingDate = dateAdd("d", 2, now())>
<cfelseif DayOfWeek(meetingDate) eq 3>
<cfset meetingDate = dateAdd("d", 5, now())>
<cfelseif DayOfWeek(meetingDate) eq 4>
<cfset meetingDate = dateAdd("d", 2, now())>
<cfelseif DayOfWeek(meetingDate) eq 5>
<cfset meetingDate = dateAdd("d", 4, now())>
<cfelseif DayOfWeek(meetingDate) eq 6>
<cfset meetingDate = dateAdd("d", 3, now())>
<cfelseif DayOfWeek(meetingDate) eq 7>
<cfset meetingDate = dateAdd("d", 2, now())>
<cfelseif DayOfWeek(meetingDate) eq 1>
<cfset meetingDate = dateAdd("d", 1, now())>
</cfif>
</cfif>
<cfdump var="#hols#">
<cfoutput> #meetingdate# <br>
#DayOfWeek(meetingDate)#</cfoutput>
|
|
riogrande |
|
06-27-2012 @ 1:28 PM |
|
|
Senior Member
Posts: 509
Joined: Mar 2003
|
Hi I worked it out here's the winning code:
<CFQUERY name="hols" datasource="salesdb">
SELECT * FROM holidays
</CFQUERY>
<cfset meetingDate = '2012-07-20'>
<cfoutput>#meetingDate#<br>
#DayOfWeek(meetingDate)#</cfoutput>
<!---<cfif ListFind(ValueList(hols.holiday), hols.holiday)>--->
<cfif ListFind(ValueList(hols.holiday), meetingDate)>
<cfif DayOfWeek(meetingDate) eq 2>
<cfset meetingDate = dateAdd("d", 2, meetingDate)>
<cfelseif DayOfWeek(meetingDate) eq 3>
<cfset meetingDate = dateAdd("d", 5, meetingDate)>
<cfelseif DayOfWeek(meetingDate) eq 4>
<cfset meetingDate = dateAdd("d", 2, meetingDate)>
<cfelseif DayOfWeek(meetingDate) eq 5>
<cfset meetingDate = dateAdd("d", 4, meetingDate)>
<cfelseif DayOfWeek(meetingDate) eq 6>
<cfset meetingDate = dateAdd("d", 3, meetingDate)>
<cfelseif DayOfWeek(meetingDate) eq 7>
<cfset meetingDate = dateAdd("d", 2, meetingDate)>
<cfelseif DayOfWeek(meetingDate) eq 1>
<cfset meetingDate = dateAdd("d", 1, meetingDate)>
</cfif>
</cfif>
<cfdump var="#hols#">
<cfoutput> #meetingdate# <br>
#DayOfWeek(meetingDate)#</cfoutput>
|
|
