2 Replies Latest reply on Apr 10, 2016 8:56 PM by Andrew Mohlmann

    Create a date field from date parts

    Andrew Mohlmann

      I have a CSV file that has the following sorts of data:

       

      YearMonthDay
      196511
      196512
      196513
      196514
      196515

       

      I wanted to create a date field based on this. I thought it would be as easy as creating a calculated field like this:

      DATE([Day]/[Month]/[Year])

       

      However this does not work, my guess is that it is because I cannot put quotation marks in it?

       

      Any tips?

       

      Thanks