Help with DATE function

[Anonymous]

I could need som help with a date function

I have in my data set a start date and an end date.

I would like to have a column set to YES, if today is between start date and end date.

In prose:

Active coloum= If "start date" is before "today" AND "end date" is after "today" set value to "yes" otherwise set value to "no"

Is this possible?

[Eric_Zhang · Accepted solution]

@Anonymous

Try 

Active column = IF('Table'[startDate]<=TODAY()&&'Table'[endDate]>=TODAY(),"yes","no")

[Anonymous]

Thank you. It works perfectly.