Forum Discussion
Not able to convert to date format
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) Conver...
Thanks erik_tarnvik! Much appreciate it!!
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])
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])
Thanks erik_tarnvik! Much appreciate it!!