Hi ppl,
Previously I made enquires abt converting DDMMYY to Qtr YY.
Example 15012019 = Qtr1 19
But now due to some requirement in company, my Qtr1 can only starts on April 2019
Meaning from April, May, June 19 = Qtr1 19
July,Aug, Sept 19 = Qtr 2 19
Oct, Nov, Dec 19 = Qtr 3 19
Jan 20, Feb20, March20 = Qtr 4 19
With such requirement on above, may i know how to I get the desired output:
example 25th May 19 = Qtr1 19
10th July 19 = Qtr2 19
Do I need some sort of VB code to achived the desired outcome ?
Seek some kind advise .
Thank you very much.
Previously I made enquires abt converting DDMMYY to Qtr YY.
Example 15012019 = Qtr1 19
But now due to some requirement in company, my Qtr1 can only starts on April 2019
Meaning from April, May, June 19 = Qtr1 19
July,Aug, Sept 19 = Qtr 2 19
Oct, Nov, Dec 19 = Qtr 3 19
Jan 20, Feb20, March20 = Qtr 4 19
With such requirement on above, may i know how to I get the desired output:
example 25th May 19 = Qtr1 19
10th July 19 = Qtr2 19
Do I need some sort of VB code to achived the desired outcome ?
Seek some kind advise .
Thank you very much.