Hi, I'm trying to add a column with a condition in it, here's the code:if((Time.Hour([Date and hour]) < 22 and Time.Hour([Date and hour]) > 😎then "Day"else "Night")But everything im getting is an error saying expecting token RightParen, what am I doing wrong? The problem seems to appear with 'then' operator.

if Time.Hour([Date and hour]) < 22 and Time.Hour([Date and hour]) > 8 then "Day" else "Night"

Forum Discussion

New Member

3 years ago

Solved

Hi, I'm trying to add a column with a condition in it, here's the code:

if(
(Time.Hour([Date and hour]) < 22 and Time.Hour([Date and hour]) > 😎
then "Day"
else "Night")

But everything im getting is an error saying expecting token RightParen, what am I doing wrong? The problem seems to appear with 'then' operator.

if Time.Hour([Date and hour]) < 22 and Time.Hour([Date and hour]) > 8
then "Day"
else "Night"

css207
Frequent Visitor
3 years ago
if Time.Hour([Date and hour]) < 22 and Time.Hour([Date and hour]) > 8 then "Day" else "Night"
- HubertHubert
  New Member
  3 years ago
  Thanks works perfectly love it
HubertHubert
New Member
3 years ago
Nope, still having the same problem, the window looks like this also the emote should be number '8'