Formula for selecting date range

[gsudharsanan]

Dear Community / Experts,

The file having data for many years. Date in YYYY-MM-DD format.  What formula to be used to filter only items relating to the previous quarter. For eg:- If running the query in April 2021 it should pick up only date range 1st Jan 2021 to 31st March 2021. Similarly, when running the query in July 2021 it should pick up only date range 1st April 2021 to 30th June 2021. 

Seek your help / support. 

Sample file attached. 

[binay2448]

Please find my updated solution hope this will work for you ...

[gsudharsanan]

Dear 

Since I am using earlier version (2020.2.3.27789)  unable to open the file. Seek your support in re-forwarding the file which can be opened in the above version.

Regards