I have a question that I hope you will be able to answer.
I want to create a digital schedule where I want to see the following information:
Conference room (name), company name, start time - end time, status (not started, on-going, ended).
Is there any way to calculate the “status” - if current time more or equal than “start time” then status is “on-going”, if current time less than “start time” then status is “not started” etc?
Thank you for your feedback!
Could you explain a little bit more how to add this function correctly.
I tried to add this formula in the DataSet column, but it seems to be is incorrect, look at the screenshot below:
It seems to be there is an error in formula, it doesn’t change the result
SELECT Start,
CASE
WHEN CURRENT_TIME() >= ‘Start’ AND CURRENT_TIME() < ‘End’ THEN ‘on-going’
ELSE ‘not started’
END FROM dataset_1