Project active today based on start and end date

257
1
Jump to solution
02-27-2023 12:29 PM
mshanaghan
Occasional Contributor

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')‍

mshanaghan_0-1677529743157.png

 

Does anyone see any issues with this expression?

Thank you!

0 Kudos
1 Solution

Accepted Solutions
mshanaghan
Occasional Contributor

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

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

 

View solution in original post

0 Kudos
1 Reply
mshanaghan
Occasional Contributor

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

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

 

0 Kudos