9 Replies Latest reply: Mar 9, 2018 3:13 PM by Cristiano Zilz RSS

    How to change date format

    Deepak Singh

      DATE

      Invoice Id

      Jan 02 2018

      12773uii

      Feb 05 2018

      22332

      02-29-2017

      123321

      03-27-2018

      9984

      04-20-2018

      ssdds8890

       

      I have date in different formats, I wants the result in number format ex: (43210), I tried it in different ways

      (Date#(Date("DATE",'DD/MM/YYYY')  and Date("DATE",'DD/MM/YYYY') but didn't got expected result.

       

      Can anyone help me to get it?