How to convert quarters and years into a date column

[94veiga]

Hello everyone, 

First of all sorry for my english. I have two columns, one of them with different years and another one with quarters and i want to create a new column with date. For example:

Year        Quarter      Date (this is the column I want)

2018             1                        01/01/2018

2017             2                        01/04/2017

2016             4                        01/10/2016

Is there any way to do this?

Thanks in advance!!!

[Fowmy · Accepted solution]

@94veiga 

Add this as a new column:

Date = DATE([Year], SWITCH( [Qtr], 1, 1, 2, 4, 3, 7, 4, 10) , 1 )

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[94veiga]

Thank you very much for your time!! I really aprecciate it!!