Join our Community in its new Home - The Datorama Trailblazer Community Group!

It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.

We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.

We can’t wait to see you there!

TotalConnect Date Transformation

Comments

  • Sushant_KamathSushant_Kamath San FranciscoSYS_ADMIN IMG42
    edited April 2021
    @JBell, I tried this formula and it seems to have worked with a test Excel file. 

    I imported the date entry as "Text", and mapped it to "Custom Classification 1" dimension, type: "Text" using the following formula - 
    FORMATDATE(PARSEDATE(csv['date'],'mm.dd.yy - mm.dd.yy'),'mm.dd.yy - mm.dd.yy')

    Let me know if this is the solution you were looking for. 

    Sushant
  • Nidene_PillayNidene_Pillay LondonSYS_ADMIN IMG42
    Hi @JBell
     
    Hope all is going well and you are enjoying the enhancements to our new TotalConnect connector? 

    You can also try using PARSEDATE(EXTRACT(csv['date'],'-',0),'d.M.yy') mapped to your 'Day' field in Datorama. 

    This will allow your file to extract a section of the date and also parse it into an acceptable format within Datorama.

    Let us know how you get on.

    Thanks,
    Nidene
Sign In or Register to comment.