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.

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Sushain 

you can use "Locale" to define UK or US format. Or otherwise change the regional settings of your system 

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
    Community 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