Wish to display dates which more than the current date and those less than the current date as "past"

Hi @newtonnyapwere
welcome to the forum! Please introduce yourself here!

I think you compare dates in a wrong way you need to convert them using decimal-date-time function first. Here is your form with fixes: anc_visit_problem (1).xlsx (9.5 KB)

2 Likes