Date calculations from FORM field

[Dan K.]

Hello everyone,

I am trying to build a site for my company that to replace our current leave
request database. This is how I would like the site to work. I would like an
end user to select the Friday of the week they are requesting time off. This
selection would be done using the Flash FORM datefield. I would then like to
have Monday - Friday's dates calculated automatically based on the Friday
date. What I am not sure is how to do the calculations and set the results
into FORM fields so when the record is submitted all of the dates get written
into the database. Any help would be greatly appreciated.

Thanks in advance.

Daniel Krajc

[jdeline]

The code below should do the date calculation for you. Untested.



<!--- fridayDate contains the user-supplied Friday date --->
<CFSET dataList = "">
<CFLOOP INDEX="i" FROM="-4" TO="-1">
<CFSET ListAppend(dateList, DateFormat(DateAdd("d", i, fridayDate),
"mm/dd/yy"))>
</CFLOOP>