5 Replies Latest reply on Sep 27, 2016 11:04 AM by Mark Fagan

    How to handle quotes in a calculated field if  quotes are a part of the name in data source?

    Mark Fagan

      store Z has beginning and ending quotes as part of the name in the data source.  How do I get the code to identify this in a calculated field?  ""store Z"" does not work, '"store Z"' does not work...I cannot seem to find a solution ...

       

      Here is the line that is affected:

       

      ELSEIF [Location] = "store Z" and [W E Date] >=#8/22/2016# and [W E Date]<=#9/17/2016# THEN "REF"

       

      Thank you in advance!

       

      -Mark