Hi,
The data in my column is
2Q/2012
1Q/2014
3Q/2011
4Q/2015
How do I translate this as
01/03/2012 00:00
01/01/2014 00:00
01/07/2011 00:00
01/10/2015 00:00
Date can be 01 but month will be first month in that quarter.
Thanks
Solved! Go to Solution.
Hi Gallup,
You could try the following formula -
todate(
right([Field1],4)+"-"+
switch(left([Field1],1),"01",
"1","01",
"2","04",
"3","07",
"4","10")+
"-01")
Just replace [Field1] for your column. EDIT - this is to create a new date/time formatted field.
Hi @JDong ,
one more formula to create a Date field:
DateTimeParse(Right([Field1], 4) + '-' + ToString((ToNumber(Left([Field1], 1)) - 1) * 3 + 1) + '-01', '%Y-%m-%d')
Best,
Roland