Forum Discussion

Sushain's avatar
Sushain
Frequent Visitor
4 years ago
Solved

Query regarding Date Format

Hello All, I am working on a project and I am stuck at a point. Plz help me out. My doubt is I am fetching a dataset from salesforce into power bi via google sheet. That dataset has a date column in...
Need Help
  • Sushain's avatar
    Sushain
    4 years ago

    Thx CNENFRNL for this solution but fyi this solution is not working. This is what I was facing but I have resolved my issue thx to tamerj1 guidance. I didn't add "en-GB" command but still the problem got resolved.

Sushain's avatar
Sushain
Frequent Visitor
4 years ago

Hi tamerj1,

I am getting this error I did some transformations. Can u help me with this? How should I resolve it?

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Sushain 

Try first transform it into decimal then to date

  • Sushain's avatar
    Sushain
    Frequent Visitor
    4 years ago

    Thx tamerj1 for your help. That didnt solve my problem. I treid doing as u said but it didn't work out. 

    Again I did some other transformations and finally its resolved now.

    Still Thanks for your help.

  • Sushain's avatar
    Sushain
    Frequent Visitor
    4 years ago

    Sure Let me try.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Sushain, 

      please share how you resolved the issue for the community to learn. Thank you! 🙂 

      Best, 

      Kelly Kaye

      • Sushain's avatar
        Sushain
        Frequent Visitor
        4 years ago

        Sure Anonymous . I will share the solution.