Current month of previous day vs last year of same month of the same day

[Ramu_i]

Hi All,

Scenario 1:

Current month vs previous month 

Current date is  : Dec-6-2021 

Sales vales is    Dec-5-2021 vs Dec-5-2020

If current Date : Jan -11-2022    Then Display the data   ------Jan-10-2022  vs Jan-10-2021

Scenario 2:

Current Quarter vs Previous year of same Quarter

---------------------------------------------------------------------

current quarter is Q4   : Now data is Dec-6-2021  

Then display ----- Oct-1-2021 to Dec-5-2021   vs    Oct-1-2020 vs Dec-5-2021

Scenario 3:

Current Year vs Previous Year

-----------------------------------------------------------------------

Current year is 2021 dec-6 

than display the Jan-1-2021   to Dec-5-2021 vs Jan-1-2020 to Dec-5-2020

Thanks Advance 

Ram

[anat]

Scenario1 :

v1=date(Today()-1)

v2==AddYears( date(Today()-1),-1)

[anat]

scenario3:

=YearStart( date(Today()-1))

=date(Today()-1)

=YearStart( AddYears( date(Today()-1),-1))

=AddYears( date(Today()-1),-1)