Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Just noticed this.
Issue:
Unless I'm way off here! Which is a possibility!
Thank you
Solved! Go to Solution.
Explain again why converting:
2017-11-01T12:00:00.000Z
Which is clearly November 1st, 2017 should convert to October 31st again?
Explain again why converting:
2017-11-01T12:00:00.000Z
Which is clearly November 1st, 2017 should convert to October 31st again?
Hi @Greg_Deckler. I messed up! I was reading the string 2017-11-01T12:00:00.000Z, as ...12:00:00AM. After changing data type to Date/Time, the new value, of 11/01/2017 05:00:00AM looked like "midnight minus 7 hours" but still on the same day (rather than moving to the previous day).
What I should have realized, is that ...12:00:00 is midday on a 24hr. time scale, NOT midnight. My mistake.
Thank you for the reply!
On this note though... how do I control the translation when moving from a STRING to DATE/TIME data type? I ask because this particular column of data has time info from MULTIPLE timezones, but the translation is blanket. It changes ALL times to my local computers time.
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |