Convert 12 Digits Integer or Text to Date Time

[arlequin71]

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-

[JirkaZ · Accepted solution]

@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.