In account record I have a custom
myDate__c field of type date.
I need to retrieve all Account records where
myDate__c is older than 45 days.
I've tried with the following query:
SELECT id, name FROM Account WHERE myDate__c <= today() - 45
However I received a warning message:
Date and number are incompatible types
How to change my query to retrieve the correct Account records?
I need only SOQL. No Apex.