2 Replies Latest reply: Jul 14, 2016 1:05 PM by Robert Fishel RSS

    Julian Date with day always 1

    Robert Fishel

      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.

       

      Any ideas?  Thanks