2 Replies Latest reply on Aug 23, 2018 12:58 AM by Nina Gough

    Custom SQL notation for end of the Previous Month

    Nina Gough

      Hi,

      I hope this a relatively straight forward question.

      I am trying to only pull data through from my Oracle datasource unto the end of the previous month dynamically and in Custom SQL, does anyone have any suggestions?

      I can create filters once the data is through but would like to have this built in through the SQL.

      I am not sure of the notation/syntax that I need to use.

      Your help would be most appreciated.

      Thanks,

      Nina