Quarter value as numeric numbers

MadhabikaM
Frequent Contributor

Quarter value as numeric numbers

Hi All,

 

Required a quick help in getting the quarter number as numeric format.

MadhabikaM_0-1611036769506.png

For example in attached screenshot, need to get the value for second line item as entered.

All Q1 Months should populate with numeric number 1, all Q2 should be populated with number 2 and so on....

Quartertodate() function gives a numeric number by month, but I need it by quarter.

 

Thanks

Madhu

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: Quarter value as numeric numbers

2 REPLIES 2
Misbah
Moderator

Re: Quarter value as numeric numbers

MadhabikaM
Frequent Contributor

Re: Quarter value as numeric numbers

Thanks @Misbah...
That helps...