- Date formatting either globally or at the user level should be set to one of the following due to a SuiteQL limitation (essentially any format with DD rather than D):
- MM/DD/YYYY
- DD/MM/YYYY
- DD-Mon-YYYY
- DD.MM.YYYY
- DD-MONTH-YYYY
- DD MONTH, YYYY
- YYYY/MM/DD
- YYYY-MM-DD