Dynamically generate last day of prior quarter based on today's date.

Tommy
Tommy ⚪️
edited January 4 in Beastmode & Analytics

Hello, I need help generating the last day of the prior quarter based on today's date. This is used to determine which variables should be displayed based on if their date column is between ranges based on the last day of the prior quarter. I have been unsuccessful in my attempts so far. Any help is appreciated.