Converting Serial Number to Data Format

Options
tompatrick.ting
tompatrick.ting Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

Hi,

 

How can i convert serial number to date format in Anaplan?

tompatrickting_0-1660543977520.png

 

 

Thanks in advance for helping.

Tom

Tagged:

Comments

  • tompatrick.ting
    tompatrick.ting Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor

    Hi @jagadishdash ,

     

    I need the 3rd approach but formula will not work:

    tompatrickting_0-1660544705517.png

    tompatrickting_1-1660544780631.png

     

  • Akhtar.shahbaz
    Akhtar.shahbaz Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Community Boss

    Hi

     

    why do you want to convert the serial number to Date format in Anaplan? it looks like it's an excel setting issue, once you fixed that then it will show the date in the file & then you can upload the data.

    Go to file -> option -> advance - untick the box which highlighted in below screenshot.

     

    Screenshot_404.png

  • SumairAhmed
    SumairAhmed Member, ALL USERS, Partner Posts: 1 New Contributor

    Thanks for detailed explanation Ryan 

Categories