2 Replies Latest reply on Feb 13, 2020 3:04 PM by Joshua Milligan

# Converting quarter date to month end date

Hi- I have a dimension date that is in quarterly. and I need to make that to monthly end date.

example; 10/31/2019 (is quarter 4)

convert to monthly end date that is 12/31/2019.

Is there a way to write a calculation that would convert the quarters to monthly end date?

• ###### 1. Re: Converting quarter date to month end date

Hey TRS,

Not sure if I understood your problem correctly. Do you have monthly data? And not sure how 10/31/2019 is quarter 4 and converting that to 12/31/2019 which is again the end date of quarter 4.

An attachment would help.

Regards,

Rohit

• ###### 2. Re: Converting quarter date to month end date

Hi TRS,

I would first truncate the date to the quarter, so 10/31/2019 would become 10/01/2019.

Then, I would add a quarter so it would become 01/01/2020.

Then, I'd subtract a day so it would become 12/31/2019.

That would work for any date.  The calculation would be: