Compare dates in a SELECT query

[BrianI]

Hi

I am trying to compare a datetime in a table to a datetime on a form using a select query in a calculated field. I have the below but it is not working...

 

CASE
WHEN
(SELECT COUNT(*) FROM ns_tbl_interviews WHERE interviewer_fk = target.[@field:interviewer_fk] AND date >=  target.[@field:date])> 0
THEN
'Time is blocked'
END

 

Any ideas?

 

Thanks

[telly]

Hi @BrianI

I’d also like to share a helpful link where you can find sample formulas for reference. It should provide you with additional insights and examples that could be useful!

https://howto.caspio.com/function-reference/