3 Replies Latest reply on Jan 9, 2017 9:17 PM by Shinichiro Murakami

    DATEPARSE not correct - misinterpreting date

    Alec Chen



      I am having difficulty parsing a float dimension [DATE] that is currently in the form "YYYYMMDD". First I convert the dimension to a STRING either directly in the Data tab, or by adding str([DATE]).


      So my formula is this:

           DATEPARSE("YYYYMMDD", str([DATE]))


      However, the date is not being recognized correctly - I have 20161202 (which should be 12/02/2016) is being recognized as 1/2/2016.


      Any ideas as to what is going on here?