Specifies an optional override for the formula used when filtering on date fields in SuiteQL queries.

Data Type

string

Default Value

""

Remarks

This property applies only when Schema is set to SuiteQL.

Use this property to override how the connector formats datetime values when applying filters in SuiteQL.

By default, the connector uses the TO_TIMESTAMP_TZ formula, which converts values to timestamps with time zone support.

You can also set this property to TO_TIMESTAMP to use an alternate timestamp conversion method without time zone handling. This can be useful if your SuiteQL filters need to match a specific datetime format or avoid time zone shifts.

Only the following values are supported:

• TO_TIMESTAMP_TZ
• TO_TIMESTAMP