Convert a number to Date

melliott
melliott
in Modeling

melliott_0-1649713227584.png

Hello, I need to convert this number formatted line item to 04/11/2022. Best approach?

 

Tagged:

Answers

  • Panji
    Panji

    Hi @melliott ,

     

    First you need convert number to text

    second you need to break data to day, month, and year

    third you need to convert data (day, month, year) to DATE

     

    Panji_0-1649733491630.png

     

    Here the Blueprint

    Panji_1-1649733540953.png

     

    Regards,

    Panji

     

  • MarkWarren
    MarkWarren

    How does this number come in to Anaplan?
    If it is imported in you could convert to date during import (assuming it comes with a leading zero, 04112022).

  • M.Kierepka
    M.Kierepka

    Hi @melliott,

    I assume it's always imported as an 8-digit number, with all leading zeros included (so it's unambiguous that i.e. 1112022 is 1/11/2022, and 11/1/2022 would be 11012022). Also in my answer I assume format MMDDYYYY, and I do conversion just on numbers (without converting back and forth to text):

    MKierepka_0-1649757579000.png

    Blueprint:

    MKierepka_0-1649757834900.png

     

     

     

Categories