Forum Discussion

TimEgerton1's avatar
TimEgerton1
Qrew Member
5 years ago

Issue with Is Null

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
------------------------------
Formulas and functions
    • TimEgerton's avatar
      TimEgerton
      Qrew Trainee
      5 years ago
      Hi Mark,

      Tried that but it causes a syntax error on "Morning" of Expecting timeofday but found text.

      Tim

      ------------------------------
      Tim Egerton
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        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
        mark.shnier@gmail.com
        ------------------------------