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

データ型

string

デフォルト値

""

解説

This property applies only when Schema is set to SuiteQL.

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

By default, the 本製品 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