Migrating from CF 4.5 to 2018 on MS SQL Server

Migrating a few websites from CF 4.5 to 2018 (I know!) and could use some assistance.  Seems CF 2018 doesn't like my syntax:

<cfquery name="CalCount" datasource="#dsn#">
SELECT ID FROM Calendar 
WHERE Approved = 1 
AND Caldate > #now()# -1 
AND WebsiteID=#application.WebsiteID#</cfquery>
Seems #now()# converts to{ts '2021-06-10 07:26:22'}
SELECT ID FROM Calendar WHERE Approved = 1 AND Caldate > {ts '2021-06-10 07:26:22'} -1 AND WebsiteID=1

CF doesn't seem to like my syntax.  Will be digging into dates and formatting, but any insights appreciated.