Getting invalid month in Dateformat
I have a website that is running the foloowing script.
<CFQUERY NAME="CreateFile" DATASOURCE="#xxxxxxx#"> INSERT INTO tblxxxxx
(LicenseID, CompanyID, LocationID, Company_Status, Company_Type, SYS_EntryDateTime)
VALUES
('#LicenseID#', '#CompanyID#', '#LocationID#', '#Company_Status#', '#Company_Type#',
'#DateFormat(Now(), "MM/DD/YYYY")# #TimeFormat(Now(), "h:mm tt")#')
</CFQUERY>
and if I look at the query run on mssql, here is what I get
('xxxxxxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxxxxxxx', '3', '6', '08/237/2022 12:05 PM')
The month value should have been 25, not 237 which is invalid.
Any thoughts would be appreciated.
