[ad_1]
Hello my question is: I have a column that has monthly, quarters and years e.g.
Time
2017 Q1
2017 Q2
2017
2016
Mar-07
Apr-07
I want to create another column such that: if it is a month then it should became the first day of the month 2015-03-01, if it is a year it shoul became the first day of the year 2017-01-01, and if it is a quarter1 then the 2017-01-01, if it is quarter 2 then 2017-04-01, if quarter 3 then 2017-07-01,if quarter 4 then 2017-10-2017. Thanks
[ad_2]
لینک منبع