Issues with Converting Text to Date
In the Dataflow, I actually concatenated the MONTH('Date Column') and Year('Date Column') but when I am trying to convert that to date using either DATE() or STR_TO_DATE() functions, I am getting no values in the column. The deired output is like "Month name - Year" which should be of a date data type. Any help is…
