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?
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?
In a Workflow of my application
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?
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.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |