8 Replies Latest reply: May 11, 2018 9:25 AM by Sasidhar Parupudi RSS

    Date into workable format?

    Chris McCafferty

      Hi All,

       

      Can someone advise as to where I am going wrong with this:

       

      =date([BD ReturnDate], ('DD/MM/YYYY'))

       

      When download a table into excel with that in it, I get the date showing correctly, but I have to do Text-to-Columns if I want to be able to sort and filter it properly.

       

       

      Thanks

      Chris