Topic: SQL statement on a calculated field

I have a SQL statement on a calculated field that has a CASE of SELECT and I just can't get it right.  Let me explain better, I have a list of services that have a date range (start and end) I have a calculated field that if the current date is greater than the end date of the service then it takes the value (text) of "finished", if  is less then it takes the value of "In progress".  Could you help me with an example?

Re: SQL statement on a calculated field

Hi Wenchester,
Perhaps try it like this (see attached).
Derek.

Post's attachments

Attachment icon wenchesterdate.zip 336.44 kb, 492 downloads since 2021-01-28