Display a week at a time

[diggy8]

I'm building a time tracking application and I want to display one work week at a time, default being the current week. Any FAQs out there about this?

 

[webmigit]

The trick, it seems, would be isolating the current day's position in the week and then figuring this distance from sunday by that date..

<cfparam name="url.datedistance" default="0">

<Cfset to_day=DayOfWeek(Now())>
<!--- If today is not Sunday (1) subtract the difference between what day it is, and 1 --->
<cfif to_day gt 1>
  <cfset to_diff=to_day-1>
  <cfset to_date=DateAdd("d",-#to_diff#,Now())>
<cfelse>
  <cfset to_date=Now())>
</cfif>

And then you query would look like..

<cfquery...>
  select * from Tracker
   where tDate > #dateAdd(to_date,0-(7+(#url.datedistance#*7)),Now())#
     and tDate < #dateAdd(to_date,0-(#url.datedistance#*7),Now())#
</cfquery>

url.datedistance is the parameter you set to navigate weeks.. IE.. This week is 0.. Last week is 1, the week before is 2, etc.. so your links would look something like...

previous week: WeekNav.cfm?datedistance=#evaluate(url.datedistance+1)#
next week (if they're currently viewing a previous week): WeekNav.cfm?datedistance=#evaluate(url.datedistance-1)#

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[diggy8]

Thanks webmigit! I modified this some and ended up using the below code which is exactly what I need!

<cfparam name="url.datedistance" default="-1">

<Cfset to_day=DayOfWeek(Now())>
<!--- If today is not Sunday (1) subtract the difference between what day it is, and 1 --->
<cfif to_day gt 1>  
  <cfset to_diff=to_day-1>
  <cfset to_date=DateAdd("d",-#to_diff#,Now())>
<cfelse>
  <cfset to_date=Now()>
</cfif>

<cfset to_date = DateAdd("ww", url.datedistance, to_date)>

<cfset dfmt = "mm/dd/yy">
<cfoutput>
	#Dateformat(dateadd("d",0,to_date),dfmt)# - 
    #Dateformat(dateadd("d",6,to_date),dfmt)# 
</cfoutput>

 

[webmigit]

Glad to hear.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.