I have the attached code for a SQL Query which I'd like to modify, but need your help on this.
CALENDAR_DATE_DIMENSION_CURRENT_CONTRACT_END_DATE.CALENDAR_DATE >= SS_DOMAIN.dbo.COMPANY_DIMENSION.CURRENT_QTR_START_DT
It basically states the contract end date needs to be equal to or greater than current quarter start date. However instead of using the current quarter start date, I want the day before this date. So if the quarter starts on July 1, I want to get June 30.
Is such a statement possible? what would be the code?