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