//**************************************
// Name: What was mondays date?
// Description:This snippet of code will calculate this past mondays date. very usefull when querying a database with a dynamic date range.
// By: Tim Garver
//
// Inputs:Todays date
//
// Returns:last mondays date and this fridays date as Dates in two variables called "mon" and "fri".
//
//This code is copyrighted and has// limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=26&lngWId=9//for details.//**************************************
<!--- This section finds last mondays date and creates a variable called mon. --->
<!--- To use this just paste this code to any CF page and call the variable mon. --->
<!--- This also finds Fridays date as well. And creates a variable for that date called fri. --->
<!--- This section is for testing different date possibilities. Change to a date you want to test from. --->
<cfset test = createdate(year(now()),month(now()),day(now()))>
<!--- End Test area --->
<!--- Sets up todays ordinal number --->
<cfset todaysnum = #dayofweek(test)#>
<!--- End --->
<!--- The IF statement checks to see what today is. --->
<!--- IF today is Tue thru Sat or (3 thru 7) --->
<cfif #todaysnum# GTE "3">
<!--- Today is Tuesday thru Saturday --->
<cfset start = (#dayofweek(test)# -2)>
<cfset str = (#day(test)# - start)>
<cfset mon = createdate(year(now()),month(now()),str)>
<cfset fri = #dateadd('d',4,mon)#>
<!--- End Tuesday thru Saturday --->
<cfelseif #todaysnum# EQ "2">
<!--- Today is Monday. So set mon to todays date. --->
<cfset mon = #test#>
<cfset fri = #dateadd('d',4,mon)#>
<!--- End Monday --->
<cfelseif #todaysnum# EQ "1">
<!--- Today is Sunday so lets look at last weeks Monday And Friday dates. --->
<cfset mon = #dateadd('d',-6,test)#>
<cfset fri = #dateadd('d',4,mon)#>
</cfif>
<!--- Ok were done. Lets output the dates. --->
This past Mondays date was <cfoutput>#dateformat(mon,'mm/dd/yyyy')#</cfoutput><br>
And Fridays date is <cfoutput>#dateformat(fri,'mm/dd/yyyy')#</cfoutput><br>
|
