Urgent help! error

Question

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.

binu_acs · Answer

@SahilArora3139

StartDate_171023.yxmd

SahilArora3139 · Answer

Yes it is in correct data format

binu_acs · Answer

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