I am trying create a ui only checkbox field that takes a date field and sees if it falls in between a start and end date field. I believe the formula should be wrapped with “AND” however that doesn’t seem to be supported.
IF({{InvoiceDate}}>={{StartDate}},{{InvoiceDate}}<={{EndDate}}, 1,0)
Question
Ui Only formula field AND""
+10This topic has been closed for replies.
+17You could try a nested IF: IF({{InvoiceDate}}>={{StartDate}}, IF({{InvoiceDate}}<={{EndDate}}, 1,0), 0)
+3You can also use “&&” for AND as well as “||” for OR
Try this:
IF({{InvoiceDate}}>={{StartDate}}&&{{InvoiceDate}}<={{EndDate}}, 1,0)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.