Format to Date

[JDong]

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

[Aaron_Harter · Accepted solution]

Hi @JDong,

Try the attached Formula:

 

[Ben_H]

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.

[RolandSchubert]

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