Skip to main content
Question

Issue with Is Null

  • March 9, 2021
  • 0 replies
  • 23 views

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 > ToTimeOfDay("12:01am") and $TOD <= ToTimeOfDay("12:00pm"), "Morning",
$TOD > ToTimeOfDay("12:00 pm") and $TOD <= ToTimeOfDay("5:00 pm"), "Afternoon",
$TOD > ToTimeOfDay("5:00 pm") and $TOD <= ToTimeOfDay("12:00 am"), "Evening",
IsNull($TOD ,"", "Other")

Thanks,

------------------------------
Tim Egerton
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • March 9, 2021
IsNull($TOD) ,"", "Other")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------