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?