This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Thanks, this helps. However, in the end result both T & F is reflecting Qtr values as 2. If my understanding is correct, one value should be 1 (first quarter) and other value should be 2 (2nd quarter). Kindly advice.
Yes, it works. Thanks a lot for your guidance & support. One more clarification. Does this mean when i run this query every quarter need to manually change the numbers as given above? I was looking for a automated solutions (without making changes every quarter should be able to run this every quarter and it should only fetch the previous quarter results). Kindly advice.