I retrieve a bunch of dynamic DateFroms and DateTos that a user has input into
a form.
<!--- Loop through the dateField IDs to get the Dates ranges--->
<cfloop list="#form.DatefieldID#" index="id">
<!--- Get the dates--->
<cfset DateFrom = form["dateFrom_" & id]>
<cfset DateTo = form["dateTo_" & id]>
<!--- Format the dates--->
<CFSET DateFrom1 = #DateFormat(DateFrom, "yyyy-mm-dd")#>
<CFSET DateTo1 = #DateFormat(DateTo, "yyyy-mm-dd")#>
<!--- Get the number of days in each period--->
<cfset DateDifference = DateDiff("d", "#DateFrom1#", "#DateTo1#")+1>
</cfloop>
I want to know the DateFrom of the first period that is more than 4 days and I
want to find out if each date range is separated by at least one day. I have
ensured that the date ranges are in chronological order and the DateFrom is
before the DateTo.
<!--- Get the DateFrom of the first period that is more than 4 days?--->
<cfif #DateDifference# GT 4>
</cfif>
Any clues would be much appreciated!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291820
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
