Forum Discussion

AndrewPF's avatar
AndrewPF
Helper V
2 years ago
Solved

datetimezone - how does it know?

I have a curious one here.  

I have two fields called FirstSeenDateText and LastSeenDateText, and I need to create an actual date/time from them. 

The code I use is: 
"FirstSeenDate", each DateTime.FromText([FirstSeenDateText], [Format="MM/dd/yyyy hh:mm tt"])
and 
"LastSeenDate", each DateTime.FromText([LastSeenDateText], [Format="MM/dd/yyyy hh:mm tt"])

and it seems to work fine, except when I subsequently change the format to datetimezone, some of them have an hour added on, and some don't (those which don't highlighted in screen shot): 

My question is: how does Power Query know which are in a different time zone, if the original data is only text? 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Power query gets the time zone from the user's local settings.

     

    Those two outliers you highlighted are probably Daylight Savings time dates, as opposed to different time zones.

     

    --Nate 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Power query gets the time zone from the user's local settings.

     

    Those two outliers you highlighted are probably Daylight Savings time dates, as opposed to different time zones.

     

    --Nate