You closed it too fast.
If(StartDate ≤ Get(CurrentDate) and EndDate ≥ Get(CurrentDate) ; "Yes" ; "No" )
Thanks for your help. Good to know I am somewhat on my way. However, it doesn't work quite yet. When I enter the Start Date, then the calculation returns "No". Whether the Start Date is in the past or future, it just remains "No" and the End Date does not have any influence on the result either. So no matter what dates I use, the result is always No. Apparently, the calculation is not correct. Anymore thoughts?
Never mind, I got it to work!
If((Start Date ≤ Get(CurrentDate) and End Date ≥ Get(CurrentDate)) ; "Yes" ; "No" )
I added one set of brackets and I had overlooked the replay existing value. Thanks for your help!
You shouldn't need that set of parenthesis around the logic clause. The IF statement will evaluated clauses up to the semi-colon. Not that they hurt anything.
I bet it was the 'replace existing...' checkbox that was the root of the problem.