Convert date to quarterly variant

[#1]

Hello,

I need some help converting regular date values (MM/DD/YYYY) into a quaterly equivalent, such that for any date in columnA, a new date in columnB is generated whose month can only be 3,6,9,or 12. This needs to be done in the load script

For example:

columnA	columnB
1/13/2016	3/1/2016
5/29/2016	6/1/2016
11/30/2017	12/1/2017
12/31/2017	12/1/2017
9/18/2018	9/1/2018

Any advice is greatly appreciated!

Regards,

Kyle Platte

[sunny_talwar]

Do you want to go to next quarter or stay in the current one for columnB?

Try on of these

QuarterStart(columnA) as columnB1

QuarterStart(columnA, 1) as columnB2

[settu_periasamy · Accepted solution]

Like this..

LOAD columnA,

     MonthStart(QuarterEnd(columnA)) as columnA1,

     columnB

FROM

[https://community.qlik.com/thread/268948]

(html, codepage is 1252, embedded labels, table is @1);

[#4]

Thanks, Settu!

Exactly what I needed.

Regards,

Kyle