cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ericOnline Member
Member

Control STRING to DATE/TIME Conversion?

Hello, 

 

When changing a STRING type column to a DATE/TIME type colum using:

 

#"Changed Type" = Table.TransformColumnTypes(
    #"Reordered Columns1",
        {
            {"weatherTime", type datetime}
        }
),

... some kind of "auto-magic" is applied to the time that I DO NOT WANT. In this case, the auto-magic is changing the string from

2017-11-01T12:00:00.000Z

to 

11/1/2017 5:00:00 AM

 

which is a -7hr translation for some reason.

 

How do I control this conversion?


Thank you

2 ACCEPTED SOLUTIONS

Accepted Solutions
ravik4934 Member
Member

i Re: Control STRING to DATE/TIME Conversion?

Hi @ericOnline,

 

It may be because of your computer timezone. 

 

Regards,

Ravi

View solution in original post

ericOnline Member
Member

Re: i Re: Control STRING to DATE/TIME Conversion?

Hi @ravik4934, you're right. I just realized that the original TimeStamp (STRING) is 12:00 PM not 12:00 AM (which would have been 00:00). 

 

Thank you for your insights.

View solution in original post

2 REPLIES 2
ravik4934 Member
Member

i Re: Control STRING to DATE/TIME Conversion?

Hi @ericOnline,

 

It may be because of your computer timezone. 

 

Regards,

Ravi

View solution in original post

ericOnline Member
Member

Re: i Re: Control STRING to DATE/TIME Conversion?

Hi @ravik4934, you're right. I just realized that the original TimeStamp (STRING) is 12:00 PM not 12:00 AM (which would have been 00:00). 

 

Thank you for your insights.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,121)