Issue with Is Null

Question

Hi,Can anyone assist with the IsNull part of this formula which is returning a syntax error of "Expecting )" at the first comma.var TimeOfDay TOD = [Interaction Time];If($TOD &gt; ToTimeOfDay("12:01am") and $TOD &lt;= ToTimeOfDay("12:00pm"), "Morning",$TOD &gt; ToTimeOfDay("12:00 pm") and $TOD &lt;= ToTimeOfDay("5:00 pm"), "Afternoon",$TOD &gt; ToTimeOfDay("5:00 pm") and $TOD &lt;= ToTimeOfDay("12:00 am"), "Evening",IsNull($TOD ,"", "Other")Thanks,------------------------------Tim Egerton------------------------------

markshnier__you · Answer

IsNull($TOD) ,"", "Other")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

timegerton · Answer

Hi Mark,Tried that but it causes a syntax error on "Morning" of Expecting timeofday but found text.Tim------------------------------Tim Egerton------------------------------

markshnier__you · Answer

Wha is your field type for this formula field?
It should be formula text.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------

timegerton · Answer

Hi Mark,I was using the wrong formula type.Thanks.Tim------------------------------Tim Egerton------------------------------

Forum Discussion

Issue with Is Null

4 Replies

Related Content

Qrew Tip: Pipeline Null Values

Access Issues

Using AND with Null values

Pipeline Filter - When text field is Not empty/Null

Formula Date Time Will not Accept Null Condition