Visokio website     Downloads     Video tutorials     KnowledgeBase  
Date/Time: inconsistent formats in a Date field - Visokio Forums
Date/Time: inconsistent formats in a Date field
  •     paola June 23, 2014 12:57PM
    Attached file deals with issue of inconsistent date formats in a single field, where few extra steps are needed to bring all the values to the same format, including use of TEXTTODATE formula.

    image
    Another useful example :
    4/18/2015 1:31:09.000000 AM
    translates into Omniscope format
    M/d/yyyy h:mm:ss.SSS a

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership