i am getting the following error on Year filter condition. after upgrading the version to 10.04

edited October 15, 2019 in Questions
Invalid syntax for field formula: IF((new Date(TODAY())>=new Date('01/01/2017') && new Date(TODAY())<=new Date('03/31/2017')),"Q1",IF((new Date(TODAY())>=new Date('04/01/2017') && new Date(TODAY())<=new Date('06/30/2017')),"Q2",IF((new Date(TODAY())>=new Date('07/01/2017') && new Date(TODAY())<=new Date('09/30/2017')),"Q3","Q4"))). SyntaxError: Expected "(" or [ x0C

x0B  ᠎ - 

   ] but "D" found.


  • edited October 15, 2019
    Wild guess is that it is the spaces between "new" and "Date". Try making it one word and see if that helps.
  • edited August 21, 2017
    Raghu -

    This formula field is using javascript syntax instead of the Skuid formula syntax.  Use the following syntax instead:
    IF((MONTH(TODAY())==1 || MONTH(TODAY())==2 || MONTH(TODAY())==3), "Q1", IF((MONTH(TODAY())==4 || MONTH(TODAY())==5 || MONTH(TODAY())==6), "Q2", IF((MONTH(TODAY())==7 || MONTH(TODAY())==8 || MONTH(TODAY())==9), "Q3","Q4")))
    You can reference this article for more information on the Skuid formulas that are accepted in the UI-Only fields:

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!