Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Is it possible to remove slashes in date and convert to number

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    To clarify, you want 01/03/2017 to show what exactly? (the examples from the link confuse me)

    01032017 - (can't be a number with a leading zero)

    1032017

    or

    132017

    If the first as text, try

    =LEFT(Date23, 2) + MID(Date23, 4, 2) + YEAR(Date23) + ""

    and then for the second, convert to number

    =VALUE(LEFT(Date23, 2) + MID(Date23, 4, 2) + YEAR(Date23) + "")

    for the last, try 

    =VALUE(MONTH(Date23) + "" + DAY(Date23) + YEAR(Date23))

    or you can mix and match those.

    LEFT and MID return numbers. MONTH, DAY, YEAR return numbers. The "" is used for force the numbers to be treated as text.

    I hope that helps.

    Craig

     

     

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories