Forum Discussion
Solved
Convert 12 Digits Integer or Text to Date Time
Hello, i'm looking for a straight forward way to convert a 12 digit Integer or Text string to Date Time.
Currently i have 2 Integer columns representing
- Date : as YYYYMMDD
- Time : as hhmmss
and i require to concatenate both to create a unique DateTime column as YYYY/MM/DD hh:mm:ss
Thanks in advance for your help,
Alex-
arlequin71 In Power Query you could do it like so (for the date). DateTime would be similar.
Please note this comes from another example where the year was not 4 characters - you'll have to adjust accordingly.
1 Reply
arlequin71 In Power Query you could do it like so (for the date). DateTime would be similar.
Please note this comes from another example where the year was not 4 characters - you'll have to adjust accordingly.