6 Replies Latest reply: Jul 25, 2017 7:48 AM by Sunny Talwar RSS

    Formula for date format identification

    Yaniv Ben Malka

      Hi All,

       

      Is there a formula that can get a date and return it's format?

       

      Example:

       

      Input: 31122015 Output: DDMMYYYY