Forum Discussion
Solved
Two timezone in the same column from the same source
Hi guys, I have some datas that are in YYYY-MM-DD, and some in DD/MM/YYYY, in the same column (the latest gives me an error that I can't transform in text, because the error comes at the first s...
Isn't this what you wanted? The error message text extracted out?
If you also want the details, you can change [Message] to [Detail]. Note that [Detail] is not a string, it is a record.
If your refering to my first post, I think I had a minor bug... just change
"DD-MM-YYYY"to
"DD/MM/YYYY"
You can, but is that what you want to do?
You can add a new column with:
let val = try [DateColumn]
in if val[HasError] then val[Error][Message] else val[Value]
