Short version: how do I check if a field is a valid date?
Long version:
Using the NetSuite connector, our data has a field called Period.
The connector does not allow me to define the data structure. I tried admin » toolkit » schema management. It doesn't hold. If I force the dataset field to a string, the next run it puts it back as a date.
When its not the end of the year, the data comes through as Jan 2024, Feb 2024, etc. At the end of the year it will come through with some data having "Adjust 2024"….which causes Domo to move to a string. Grrr.
I wish Domo would stop guessing at data structures, it always gets them wrong!
I need some logic to test whether Period is a date. But I can't find an equivalent Domo command to IsDate or ParseDate, etc. I need to check if the field is a date and if it is a date convert it using DATE_FORMAT(Period
,'%b %y'). If it's not a date, leave it alone.