Need help with Calculated field expression

[MariaCr2]

Hi! 

We have a field on our custom forms asking which quarter a project is planned to be competed in (Q1, Q2, etc.). The field name is {DE:What quarter was this project planned to be completed within the quarterly plan?}. I need to compare this field to when the project is actually completed (so if a project closes out anytime between January 1 and March 31, it would be completed in Q1). Field name: {actualCompletionDate}.

I need guidance on how to even start approaching this calculation in Workfront. If anyone has thoughts, I would really appreciate it. 

[lgaertner]

Hello,

You could do this:

IF(CONCAT("Q",CEIL(MONTH(CLEARTIME({actualCompletionDate}))/3))={DE:What quarter was this project planned to be completed within the quarterly plan?},"equal","unequal")

Does this help?

Regards

Lars