https://myvisualdatabase.com/forum/viewtopic.php?id=7304 Thu, 28 Jan 2021 12:07:27 +0000 PunBB https://myvisualdatabase.com/forum/viewtopic.php?pid=39880#p39880 Hi Wenchester,
Perhaps try it like this (see attached).
Derek.

]]> Thu, 28 Jan 2021 12:07:27 +0000 https://myvisualdatabase.com/forum/viewtopic.php?pid=39880#p39880 https://myvisualdatabase.com/forum/viewtopic.php?pid=39877#p39877 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?

]]> Thu, 28 Jan 2021 03:46:43 +0000 https://myvisualdatabase.com/forum/viewtopic.php?pid=39877#p39877