Urgent help! error

[SahilArora3139]

I’m trying to put some condition on my data but its not working . I do not know the reason please help

IIF( [start date] >= [absencestartdste]

And [startDate] <= [absenceEndDate],

”red”,”green”)

please let me know any other logic based on this i need to fulfill both criteria(between logic) that is absence start date and absence end date.

[binuacs]

@SahilArora3139 your formula is fine, can you make sure that your date fields are in date type?

[SahilArora3139]

Yes it is in correct data format

[binuacs]

@SahilArora3139