2 Replies Latest reply: Nov 3, 2016 5:06 AM by Benoît Gochel RSS

    Date reversed when parsed

    Benoît Gochel

      Hi all,

       

      I have a little problem with my date creation for an app.

       

      I have .csv file, with a field that represent a timestamp, for example "01-09-2016  07:49:00".

      I try to create a date field on my script like this :


      date(ceil("Time"), 'DD-MM-YY') as "Date"

       

      But when I use my field date on a dashboard I get something like "16-09-2001". The date is reversed and I don't know what I do wrong.

       

      Can someone help me please?

       

      Thank you in advance.