Forum Discussion

AUshYC's avatar
AUshYC
Qrew Trainee
4 months ago

Formula to test if a date falls in range compared to other dates - Expect Error

Hello, I'm attempting to build a formula field that will mark a checkbox if [Date] is within 2 days of [Original Referral Date] OR [Date] is within 2 days of [Client - Re-opened Date] OR [Date] is w...
formulas
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 months ago

My guess is that you have the field type as formula text.  If so, then you can change the field type to formula checkbox. It will preserve the formula when you make that change. 

  • AUshYC's avatar
    AUshYC
    Qrew Trainee
    4 months ago

    Hi Mark, thanks for the tip. I double checked and the field type is formula checkbox and the formula is still not working. It turned out the Date was already in date format and I did not need to include ToDate. That explains why it was expecting text!