I have two columns with string dates called Start month and end Month as "yyyy-mm" but I need to convert them into a Date data type. for that, I add a Transformation or Calculated column:
The Start month is easy to parse:
Date(Integer(left([Start Month],4)),Integer(right([Start Month],2)),1)
For the end month, I have to add a month and extract one day after I parse the date:
DateAdd('day',-1,DateAdd('month',1,Date(Integer(left([End Month],4)),Integer(right([End Month],2)),1)))
The Start month is easy to parse:
Date(Integer(left([Start Month],4)),Integer(right([Start Month],2)),1)
For the end month, I have to add a month and extract one day after I parse the date:
DateAdd('day',-1,DateAdd('month',1,Date(Integer(left([End Month],4)),Integer(right([End Month],2)),1)))
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon