How to test for no data in a TIME column type...

expressions
(Colin) #1

How to test for no data in a TIME column type?

I have tried ot test for no data in a TIME column type with this expression:

ISBLANK(FINISH_NEXT_CONTACT_TIME)

However, it is not detecting this column as having no data (i.e. blank).

What expression should I use instead?

(Praveen Seshadri (AppSheet)) #2

ISBLANK() should always return true if the value of the column is blank. There should be nothing special about a Time column type.

Where are you using this expression?

(Colin) #3

In a Workflow of my application

(Aleksi Alkio) #4

Would you please give us more details about the usage. Do you have it in the condition rule or in a template or somewhere else?

(Colin) #5

Its in a workflow action of change data, in the section of:

…IF THIS IS TRUE…

Condition

OR(ISBLANK(FINISH_NEXT_CONTACT_TIME), [FINISH_NEXT_CONTACT_TIME] < [START_NEXT_CONTACT_TIME])

with an Update event of ADDS_AND_UPDATES

it will …DO THIS

Reaction Change data

Action to update the FINISH_NEXT_CONTACT_TIME to being 10 minutes later than the START_NEXT_CONTACT_TIME

When I check the the test results, I can see that the expression part:

[FINISH_NEXT_CONTACT_TIME] < [START_NEXT_CONTACT_TIME]

will work, but the:

ISBLANK(FINISH_NEXT_CONTACT_TIME)

will not.