Forum Discussion
Solved
Extract ISO 8601 Date-Time and Convert it to Date-Time-Format
short explanation of the initial situation: I have a table in which answers come back. In addition, I receive the information about the data type of the answer. Furthermore I get the information unti...
Hi, DerMoe
Here it's in Power Query:#"Added Custom" = Table.AddColumn(#"Changed Type1", "TransformedAnswer", each if [Datatype] = "DATETIME" then [Answers] else null), #"Changed Type2" = Table.TransformColumnTypes(#"Added Custom",{{"TransformedAnswer", type datetime}}) in #"Changed Type2"
WOW! Thank you for that realy quick answer! You helped me a lot
DerMoe
Happy to help,
if you could please Kudo my answer to help me out, I would appreciate that.
Thank you