Date Conversion

Comments

3 comments

  • Avatar
    Kobbi Gal

    if n2d.str is the name of the column that you want to manipulate then:

     

    40598 -> 4/05/1998:

    concat(concat(concat(left(ToString(n2d.str),1), '/'), substring(tostring(n2d.str),2,2)),concat('/19',right(tostring(n2d.str),2)))

     

    122118 -> 12/21/2018

    concat(concat(concat(left(tostring(n2d.str),2), '/'), substring(tostring(n2d.str),3,2)),concat('/20',right(tostring(n2d.str),2)))

     

    Use the examples above to parse the second example as they should be quite similar.

    If you need to convert them to Date datatype, you'll need to use the CreateDate function.

    0
    Comment actions Permalink
  • Avatar
    Karen Rasnick

    I would like to schedule 30 minutes to review a few examples.  Can we schedule a meeting?  

    0
    Comment actions Permalink
  • Avatar
    Kobbi Gal

    Hi Karen,

     

    Please contact your Customer Success Manager Shirley Alter to set up a BI Consultant session.

    0
    Comment actions Permalink

Please sign in to leave a comment.