Forum Discussion
Solved
Converting Text into Date
Hi folks, The dataset I am currently work has a text field called [Last Executed On]. It contains "0" or a date in the following format: yyyyMMddhhmmss. How can I convert it to a Date (or Da...
Yes, the first double quotes of the table name must be preceded by a hash: #
#"Inserted T" = Table.TransformColumns(#"_RSALL_FULL_PERNR-USERS",{{"Last Executed On", each if _ = "0" then null else Text.Insert(_,8,"T"), type text}}),
Yes, the first double quotes of the table name must be preceded by a hash: #
#"Inserted T" = Table.TransformColumns(#"_RSALL_FULL_PERNR-USERS",{{"Last Executed On", each if _ = "0" then null else Text.Insert(_,8,"T"), type text}}),
It worked!
Thank you so much!