Seeing NULL data points where there should be dates?

  • 28 June 2023
  • 0 replies
  • 38 views

Userlevel 1
Badge

When using a CData NetSuite connector for a NetSuite data source, you may encounter NULL data values that correspond to Date fields in your original data. This has been seen occurring when using the SuiteQL API in particular.

To remedy the situation, one solution is to use a TO_DATE function in your SQL statement. For example, a field called “Purchase”.purchaseDate would be included in a manner such as the following:

TO_DATE(“Purchase”.purchaseDate, ‘YYYY-MM-DD’) AS “purchase_date”

where the date format and alias are adjustable based on your needs.


0 replies

Be the first to reply!

Reply