cfml

Edit: It appears that date strings are no longer being implicitly converted into dates in Lucee 6.

(Lucee 6 breaking change)

<https://cffiddle.org/app/file?filepath=49287eb1-14a0-4ad6-b721-ebf3ba6938dd/a721706d-37e0-485e-9e37-e9be47502424/2decca14-6ac3-43a0-a63a-df19bce7242c.cfm|https://cffiddle.org/app/file?filepath=49287eb1-14a0-4ad6-b721-ebf3ba6938dd/a721706[…]85e-9e37-e9be47502424/2decca14-6ac3-43a0-a63a-df19bce7242c.cfm>

I receive the same result on Lucee 6.0.183 as I do AFC 2023

I'm looking deeper into the report, where we're getting 'can't cast empty string to a number value'

Was there a thing where empty strings in lists/arrays were previously ignored in cfloop but aren't now?

You are turning a string to a date. you should have a CFPARAM defaults for all values, not that its ideal.

Sorry, the error is actually "cannot cast [04/26/2024] string to a number value"

`cfloop(from = acceptancedaterange.acceptance_start_date, to = acceptancedaterange.acceptance_end_date, index = "i", step = createTimespan(1, 0, 0, 0)) {`

This is the code that used to work that doesn't anymore

Note that acceptance start_date is set to:

`acceptancedaterange.acceptance_start_date = dateFormat(retstartDateTime, "mm/dd/yyyy");`

So it's not implicitly converting strings to date, it seems

Here's a sample of breaking code:

```&lt;cfset fromDate = Now()&gt; 
&lt;cfset toDate = dateFormat(Now() + 30, "mm/dd/yyyy")&gt; 
&lt;cfloop from="#fromDate#" to="#toDate#" index="i" step="#CreateTimeSpan(7,0,0,0)#"&gt; 
&lt;cfset i = dateAdd("d", 0, i)&gt;&lt;!--- converts number to date ---&gt;
    &lt;cfoutput&gt;#i.dateTimeFormat("mm/dd/yyyy")#&lt;/cfoutput&gt; 
&lt;/cfloop&gt;```

createDate has to be involved, I guess, which will involve extracting each date part

Here's a workaround:

```&lt;cfset fromDate = Now()&gt; 
&lt;cfset toDate = DateFormat(Now() + 30, "mm/dd/yyyy")&gt;
&lt;cfset convertedToDate = createDate(Year(toDate), Month(toDate), day(toDate))&gt; 
&lt;cfloop from="#fromDate#" to="#convertedToDate#" index="i" step="#CreateTimeSpan(7,0,0,0)#"&gt; 
&lt;cfset i = dateAdd("d", 0, i)&gt;&lt;!--- converts number to date ---&gt;
    &lt;cfoutput&gt;#i.dateTimeFormat("mm/dd/yyyy")#&lt;/cfoutput&gt; 
&lt;/cfloop&gt;```

Fairly common, converting a datetime to a date in order to strip off the time string and default to 00:00:00 so the start date includes all of the day in question

A more concise working version:

```&lt;cfset fromDate = Now()&gt; 
&lt;cfset toDate = DateFormat(Now() + 30, "mm/dd/yyyy")&gt;
&lt;cfloop from="#fromDate#" to="#parseDateTime(toDate)#" index="i" step="#CreateTimeSpan(7,0,0,0)#"&gt; 
&lt;cfset i = dateAdd("d", 0, i)&gt;&lt;!--- converts number to date ---&gt;
    &lt;cfoutput&gt;#i.dateTimeFormat("mm/dd/yyyy")#&lt;/cfoutput&gt; 
&lt;/cfloop&gt;```