Hello everyone. I have a date column with five digit dates (Julian, I think) that I need to convert to m/d/yyyy. I tried
Date(datefield, 'm/d/yyyy') as new date
However, the dates look like (for example) 0/1/2015 after conversion of a date 42339. The original data appears to have the month, a 1 for the day (always) and the year for this column. The correct answer for this date should be 8/1/2015.