Date/Time Sheet Application

Thank you all for your help. It works.


Sevor Klu

startdate = now();
while(dayofweek(startdate) gt 1) // 1 is Sunday
startdate = dateadd("d", -1, startdate);

enddate = dateadd("d", 7, startdate);

That should get you started.

Depending on which day you want to start the row on...

<!--- find today's day and discover how many days its been since saturday. subtract 5 days from friday to get the date of sunday --->
<cfif DateFormat(NOW(), 'DDDD') EQ 'Friday'>
<CFSET startDate = DateAdd('d',-5, Now())>
<cfelseif DateFormat(NOW(), 'DDDD') EQ 'Thursday'>
<CFSET startDate = DateAdd('d',-4, Now())>
<cfelseif DateFormat(NOW(), 'DDDD') EQ 'Wednesday'>
<CFSET startDate = DateAdd('d',-3, Now())>
<cfelseif DateFormat(NOW(), 'DDDD') EQ 'Tuesday'>
<CFSET startDate = DateAdd('d',-2, Now())>
<cfelseif DateFormat(NOW(), 'DDDD') EQ 'Monday'>
<CFSET startDate = DateAdd('d',-1, Now())>
<cfelseif DateFormat(NOW(), 'DDDD') EQ 'Sunday'>
<CFSET startDate = DateAdd('d',-0, Now())>
<cfelseif DateFormat(NOW(), 'DDDD') EQ 'Saturday'>
<CFSET startDate = DateAdd('d',-6, Now())>
</cfif>

then do something like this to output...

<TABLE width="80%" cellpadding="0" cellspacing="0" border="1">
<TR bgcolor="e6e6e6">
<TD>Sun</TD>
<TD>Mon</TD>
<TD>Tues</TD>
<TD>Wed</TD>
<TD>Thur</TD>
<TD>Fri</TD>
<TD>Sat</TD>
</TR>
<TR bgcolor="ffffff">
<!--- loop from 0 to 6 (sunday to saturday) --->
<CFLOOP FROM="0" TO="6" STEP="1" INDEX="day">
<CFSET thisDate = DateAdd('d', day, startDate)>
<CFQUERY NAME="thisTime" DBTYPE="QUERY">
SELECT InDate, OutDate
FROM your dbtable
WHERE InDate >= <cfqueryparam value="#DateFormat(thisDate,'m/d/yyyy')#" cfsqltype="cf_sql_date">
AND InDate <= <cfqueryparam value="#dateAdd('d', 1, thisDate)#" cfsqltype="cf_sql_date">
</CFQUERY>

<TD><div align="center"><cfoutput>#thistime.InDate# - #thistime.OutDate#</cfoutput></div><br></TD>

</CFLOOP>
</TR>
</TABLE>

this should start you in the right direction, the key here is what data are you outputing. or are you just wanting to output a calendar like week?