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.