3 Replies Latest reply: Aug 17, 2015 6:15 AM by Peter Svendsen RSS

    My date is not shown correct, maybe script error

    Peter Svendsen

      Hi all,

       

      I have a field in my xls stating the date in the format DD-MM-YYYY and when I display this it simply write a value.

      I have tried to use the table list to give me the correct value, but without luck.

      If I in the script write

      date(date#([my date], 'DD-MM-YYYY'), 'DD-MM-YYYY') as MyDate,

       

      I get the same problem.... why is that?

       

      Thanks

      Peter