5 Replies Latest reply on Dec 10, 2014 9:47 AM by CarlosCannelloni

    Normalize OS - NT Info - Install Date

    Apprentice

      Hi,

       

      I would like to know, how many devices we deploy per month. Therefore "OS - NT Info - Install Date" seems to be a good starting point. My problem is though, that there are many different date formats in this field:

       

      dd.mm.yyyy

      yyyy.mm.dd

      m/d/yyyy

      yyyy-mm-dd and more..

       

      We have Data Analytics installed and thus could use a "Normalize" function. Is there anyone out there, who has already done this or somebody with an idea on how to achieve this?

       

      Thank you for your help.