Forum Discussion

ericOnline's avatar
ericOnline
Post Patron
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi ericOnline,

     

    It may be because of your computer timezone. 

     

    Regards,

    Ravi

  • ericOnline's avatar
    ericOnline
    7 years ago

    Hi Anonymous, 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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi ericOnline,

 

It may be because of your computer timezone. 

 

Regards,

Ravi

ericOnline's avatar
ericOnline
Post Patron
7 years ago

Hi Anonymous, 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.