We have a column that contains dates, strings and integers. The data is CDC data. We have been having issues with the date field coming up as a number (Julian Date) rather than a date. I have tried using the alt function to determine that the date is not shown as a number. Is there any way to resolve this.
For this you need to use date() and date#() to convert and format these values - probably within a few if-loops to catch each varity of dates, strings and numerics.
