DawnRene3
3 years agoQrew Trainee
Formula Checkbox formula not working for to check dates before today
I am trying to create a formula checkbox for if a checkbox field is not checked and a date field is before today, check this box. It is not working and I can't figure out why. This is what I have:
If([Modifications Finalized Checkbox],false & [Session Date]<Today(),true, false)
It is telling me that I cannot use '<' because that cannot be used on type text and date. Session Date is a formula date field: ToDate([session_start_time])
Can anyone assist?
------------------------------
Dawn Rene
------------------------------
If([Modifications Finalized Checkbox],false & [Session Date]<Today(),true, false)
It is telling me that I cannot use '<' because that cannot be used on type text and date. Session Date is a formula date field: ToDate([session_start_time])
Can anyone assist?
------------------------------
Dawn Rene
------------------------------