SuiteQL

doesn’t seem to allow me to do this though. I’m trying

SELECT (CAST(current_timestamp AS DATE) - CAST(custrecord_check_datetime AS DATE)) * 86400 AS seconds

but it’s crabbing that it’s an invalid or unsupported search.