Get Current Qtr from different date fields

[apthansh]

Hi - I have to get current Qtr and next Qtr from 2 different date fields from 2 diff. tables.How can I do that ?I have the attached MC.

Table1:

ID Date1

1  7/9/2020

2 7/9/2019

3 7/9/2021

Table 2:

ID Date2

1  6/9/2020

2 6/9/2019

3 6/9/2021

Then I have to replace the Qtr in the expression below.

I have 8 Expressions which should autoupdate for the rolling next 24 months.

Exp1 - 

=if(year([Date1])=2020 and 'Q' & ceil(month([Date1])/3) ='Q3'

and

 year([Date2])=2020 and 'Q' & ceil(month([Date2])/3) ='Q3','Current'

Exp2 - 

=if(year([Date1])=2020 and 'Q' & ceil(month([Date1])/3) ='Q4'

and

 year([Date2])=2020 and 'Q' & ceil(month([Date2])/3) ='Q4','Next1'

Exp3 - 

=if(year([Date1])=2021 and 'Q' & ceil(month([Date1])/3) ='Q1'

and

 year([Date2])=2021 and 'Q' & ceil(month([Date2])/3) ='Q1','Next2'

Thank you very much.