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) 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:
Thanks erik_tarnvik! Much appreciate it!!
3 Replies
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!!
