Deriving Previous quarter end date based on a particular date

Question

I have a date 2023-06-30( 2nd quarter end date) and based on it I want to derive last (1st quarter end date). It should be 2023-03-31. The formula datetimeadd([Current_Quarter], -3, 'months') is giving me 2023-03-30 instead of 2023-03-31. Any suggestions on how I can solve for it?

Thanks in advance

Prometheus · Accepted Answer

@Idyllic_Data_Geek  Finding the last day of a past month can get hairy if you're using DateTimeAdd and DateTimeLastOfMonth, but if you find the first of the past month you're looking for and subtract a day, you'll be set.