I am trying to get the day of a week in a SOQL query but the marketingcloud just shows me this error message:
"Error:'day_in_week' is not a recognized built-in function name."
This is the query I am using in the moment:
SELECT CreatedDate, Id FROM Request__c_Salesforce WHERE day_in_week(CreatedDate)= 2
Does anybody know how to solve this error?