Is true if time is greater than 7PM Today

I have a sign out/in application for my clients, I am going to create a workflow that emails their case manager if they missed curfew.

So what I am having trouble with is wording the expression that will make the column “Missed Curfew” true or false.

This is what I have come up with but ummmm it’s not gonna work lol

Solved Solved
0 1 186
1 ACCEPTED SOLUTION

You might want to try something like:

OR(
	AND([Date]=TODAY(), ISBLANK([Time In:])),
	AND([Date]=TODAY(), [Time In:]> TIME(“19:00:00”))
)

View solution in original post

1 REPLY 1

You might want to try something like:

OR(
	AND([Date]=TODAY(), ISBLANK([Time In:])),
	AND([Date]=TODAY(), [Time In:]> TIME(“19:00:00”))
)
Top Labels in this Space