I have Dremio reading a Tilde delimited file.
If I have two rows in that file as
ISDATE returns FALSE - when it IS a date, but there appears to be no documented way to handle this UK format?
Now the UI utilises TO_DATE(EffectiveDate, ‘DD/MM/YYYY’, 1) , but I assume there is a reason this isn’t in the documentation? This seems to handle the empty text scenario/invalid date scenarion
So, when the column in the source file is empty (see row 2, column 2), without using TO_DATE, how can I achieve what TO_DATE does?