Project active today based on start and end date

[mshanaghan]

I am trying to calculate a field that will autopopulate with 'Yes' if the project start date is before today and end date is after today, i.e.. the project is active today. My calculation field contains this:

if(${start_date} .< today() and ${end_date} .> today()), 'Yes', 'No')‍

Does anyone see any issues with this expression?

Thank you!

[mshanaghan · Accepted solution]

Solved! If anyone is interested, this is the correct syntax:

if(${start_date} < today() and ${end_date} > today(), 'Yes', 'No')