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.
