The preferred date format set in NetSuite UI.

Data Type

string

Default Value

"MM-dd-yyyy"

Remarks

The preferred date format set in NetSuite UI. This format should be used when filtering based on Date. You can change the date format in NetSuite UI using Home -> Set Preferences -> Formatting.

Available values are: 'M/D/YYYY', 'D/M/YYYY', 'D.M.YYYY', 'D-MONTH-YYYY', 'D MONTH, YYYY', 'YYYY/M/D', 'YYYY-M-D', 'DD/MM/YYYY', 'DD-MON-YYYY', 'DD.MM.YYYY', 'DD-MONTH-YYYY', 'DD MONTH, YYYY', 'MM/DD/YYYY', 'YYYY/MM/DD', 'YYYY-MM-DD'.

Note:This property is only applicable for SuiteQL Schema. If the two formats are mismatched, the server throws an exception.

This property only applies when Schema is set to SuiteQL.