<!--- 20200827 Adobe ColdFusion TimeFormat Bug?
      When dumping data to Excel, some strings are incorrectly autocast as date/time values.
      Blog: https://dev.to/gamesover/coldfusion-timeformat-conversion-testing-3m81
      TryCF Lucee: https://www.trycf.com/gist/923f645b3944b7315c22ac693c17e94b/lucee5
      TryCF ACF2016: https://www.trycf.com/gist/923f645b3944b7315c22ac693c17e94b/acf2016 
      TryCF ACF2018: https://www.trycf.com/gist/923f645b3944b7315c22ac693c17e94b/acf2018
--->

<cfset tests = ["9", "9A", "9p", "9#CHR(32)##CHR(32)##CHR(32)#A  ", " 9 A ", "23", "15.4"]>

<cfoutput>
    <cfloop array="#Tests#" index="thisTest">
        <div>"#thisTest#" = #isValid("time", thisTest)#
        <cftry>
            "#TimeFormat(thisTest, 'HH:mm:ss.lll')#"
            <cfcatch>ERROR"</cfcatch>        
        </cftry>
        </div>
    </cfloop>
</cfoutput>