Discussions

Expand all | Collapse all

Why am i seeing this syntax error?

  • 1.  Why am i seeing this syntax error?

    Posted 06-21-2018 18:21
    Hello, i think this is simple question, do you know why i am seeing this formula syntax error? The formula seems to be working fine... 
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1736714/RackMultipart20180621-116505-ha6v6x-Capture_3_inline.JPG?1529605300"> 


  • 2.  RE: Why am i seeing this syntax error?

    Posted 06-21-2018 19:18
    is it giving an error when you save the field?  i've noticed periodically that it will show "live" syntax errors in the formula itself, but upon saving and reopening the formula is fine.


  • 3.  RE: Why am i seeing this syntax error?

    Posted 06-21-2018 19:20
    No error when saving but it shows up when i reopen the field....


  • 4.  RE: Why am i seeing this syntax error?

    Posted 06-21-2018 22:59
    What does it state when you mouse over the error triangle?


  • 5.  RE: Why am i seeing this syntax error?

    Posted 06-21-2018 23:00
    It says expecting date... 


  • 6.  RE: Why am i seeing this syntax error?

    Posted 06-21-2018 23:06
    Then try ToDate(what is already there)


  • 7.  RE: Why am i seeing this syntax error?

    Posted 06-21-2018 23:07
    You may need to set up a formula text field with your formula in it to see what it returns in order to format then convert to a date