Salesforce Connector - Filter by current date

Fabian Tiemann · 05/27/20

Dear Ladies & Gents,

is there a possibility to filter by using datetime fields in salesforce and compare them to date literals, e.g.:

take only records where a datetime field contains a value greater than the current date?

Thanks a lot.

Kind regards,

Fabian

Ramzi K · 05/27/20

Hi @Fabian Tiemann,

There is currently no way to filter out data in the connector based on a "relative date" like Today() for example.

Your best bet is to use a static date if you can to limit some of the volume of data coming from SF then filter the data out in Smartsheet either using filters or moving unwanted rows to another sheet.

Hope that helps,

Ramzi

Ramzi K · 05/27/20

Hi @Fabian Tiemann,

There is currently no way to filter out data in the connector based on a "relative date" like Today() for example.

Your best bet is to use a static date if you can to limit some of the volume of data coming from SF then filter the data out in Smartsheet either using filters or moving unwanted rows to another sheet.

Hope that helps,

Ramzi

Fabian Tiemann · 05/28/20

Ramzi, thanks a lot.

Salesforce Connector - Filter by current date

Best Answer

Answers

Categories