date dimension comparison with date range

[Ginto]

Hi I’m using a derived table view with this conditional clause below. How do you translate this from snowflake tol lookml? Please advise

where
MSG_TIMESTAMP >= ‘&RPT_DAY_SF’::timestamp - interval ‘&DAYS_BACK days’ + interval ‘&CUTOFF_HOUR hours’
AND MSG_TIMESTAMP < ‘&RPT_DAY_SF’::timestamp + interval ‘&CUTOFF_HOUR hours’

&RPT_DAY_SF --> today’s date
&DAYS_BACK --> number of days e.g. 1
&CUTOFF_HOUR --> number of hours e.g 5