cfml

Can you make a sample gist on TryCF   because you have four input variables which we have no way of knowing what you tried to get your errant results...

yes based on the error, the date “07/197/2022” is not a date

but we dont know what line that is happening on or what variable name

it does since if this `writeoutput(dateformat('07/16/2022','DD'));` yields `197`

My bet would be that `WkStrt_Dow` is a string that was created via a badly-formed `dateFormat` call, and the code posted is demonstrating a symptom, not the actual problem.

This is why <@U0C1769MZ>’s advice is critical when asking questions. Don't past some part of your app that tells us nothing.

Post a self-contained, *runnable* piece of code that shows the problem happening.

<http://sscce.org/> / <http://www.catb.org/~esr/faqs/smart-questions.html>

Not least of call because in the act of creating the SSCCE to show to other ppl, one generally actually solve the problem for one's self.