7 Replies Latest reply: Jun 28, 2017 10:09 AM by Juan Patricio Iorio RSS

    Where statement

    Phil Speight

      Can anyone help.  I need a where statement in my script which only includes any rows with the following criteria :


      All data for company 'ABCD' where the status is NOT in authorised status and the create date > 365 ago

       

      The script below does not work.

       

      Where Company = 'ABCD' and

       

      (Status<>'Authorised' and CreateDate>=(Today()-365))

       

       

      Thoughts anyone?

       

       

      Please help

       

       

      Thanks

       

       

       

      Phil