2 Replies Latest reply: Jan 27, 2016 4:29 PM by Stefan Wühl RSS

    How do I fix this mix format of dates issue in a Date field?

    Michael Wallman

      Hello friends!

       

      I have the following table:

       

      Date
      Value
      11-Nov-2015330
      15/01/2016400
      16/01/2016500
      21-Feb-2015600

       

      How do I solve the mix format of dates in the Date field to a single consistent format of DD/MM/YYYY?

       

      I have tried using Date, Date#, MakeDate functions but did not have much luck solving the problem. My attempts ended up excluding the string based dates.

       

      How can I solve this?