I am using the Sales Force Marketing Cloud connector and I receive the error; "[fieldname] is not a retrievable property" when trying to use a date field for net change or apply any filter in a query block.
I figured out the issue but not sure we can resolve it on our end. Most of the field/column names in the data extension contain and "_" The date field "date_created" generates this error: [Error: The Filter Property 'Date.Created' is not a retrievable property] when used in net change. If I change the column name to DateCreated, it works fine. The error message shows the name as "date.created" where the actual name is "date_created" - I'm guessing that is where the issue lies. There is a lot of complexity involved in changing the data extension column names at this point (they are tied to many forms used to submit data). This solution is required for the GDPR requirements being implemented this month. Any thoughts?