Not able to convert to date format

[Anonymous]

Hello experts:

I am trying to merge 3 columns in one converting the final result into date format.

1) Merging the columns: StartDate=[Start date.2.2]/[Start date.2.1]/[Start date.2.3]

2) Converting to Date format

However the final result is messed up! The dates don't match against the original data.

Would someone have any suggestion? How to do that?

1) Merging these 3 cols:

[erik_tarnvik]

In Power Query you must use the functions available in the Power Query language (sometimes called M). If your columns are numbers, your formula is a division, not a concatenation of strings.

Try writing the same as this:

= Text.From([Start date.2.2]) & "/" & 
  Text.From([Start date.2.1]) & "/" & 
  Text.From([Start date.2.3])

[erik_tarnvik]

Or if you want the column to conatin an actual date rather than a text string representing a date, try

= #date([Start date.2.3],[Start date 2.1],[Start date 2.2])  

[Anonymous · Accepted solution]

Thanks @erik_tarnvik! Much appreciate it!!