Field for checking if a date falls between a range of days - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Mir HossainMir Hossain 

Field for checking if a date falls between a range of days

Essentially I want to create a checkbox that evaluates to true it has been x < order date < x

so for this formula I want it to evaluate to true if 31 Days since order start date < order start date < 60 Days since order start date 

 

I think my logic is correct but I'm having some trouble figuring out what i'm doing wrong (syntax wise)

 

Heres my formula: IF(
      AND((TODAY() - EffectiveDate) >= 31),(TODAY() - EffectiveDate) <= 60)) , TRUE, FALSE) 

Best Answer chosen by Mir Hossain
Mir HossainMir Hossain
IF(
  AND 
    (((TODAY() - EffectiveDate) >= 31), 
        ((TODAY() - EffectiveDate) <= 60)) , TRUE, FALSE)

Had mismatched parenthesis, it was much easier just copying and pasting my formula into an IDE that visually matches parenthesis