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

    DATEPARSE not correct - misinterpreting date

    Alec Chen

      Hi,

       

      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?

       

       

      Thanks.