I have tasks that are automatically generated. I want to know however, if this was done outside of work hours.
I can check for the day, to see if it's a weekday or weekend. However, how can I check, for example if the time that I get back with a formula is say before 8am and after 3:45pm?
CASE WHEN ({createddate}, 'HH24:MI') >= 15:45 THEN 1 ELSE 0 END
doesn't work. ERROR: Invalid Expression.
I get that.. The time it is comparing to may not work, plus the createdate format is something that doesn't work for date/time, but only for text, from what I can see.
I've tried to instead create a time/date field and fill that with a value… and that's great, but when I display it as date/time, it picks the first of the month with the time I gave it. So then I cannot compare it with today's date and time for example.
What's the best way to approach this?