Ui Only formula field "AND"

edited October 15, 2019 in Questions
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) 

Comments

  • edited October 15, 2019
    You could try a nested IF: IF({{InvoiceDate}}>={{StartDate}}, IF({{InvoiceDate}}<={{EndDate}}, 1,0), 0)
  • edited October 28, 2016
    You can also use "&&" for AND as well as "||" for OR

    Try this:
    IF({{InvoiceDate}}>={{StartDate}}&&{{InvoiceDate}}<={{EndDate}}, 1,0) 

  • edited December 2, 2016
    Thank you both. I went with Will's answer but will keep both in mind for the future.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!