4 Replies Latest reply: May 17, 2016 11:19 AM by Filip Duchateau RSS

    How can I do this type of date range filter in the script with the current/today's date?

    John Blomqvist

      Hi all,

       

      In my script I would like to do the following:

       

      For example, today is 17th May 2016. In the where clause I would like the script to automatically calculate the following:

       

      Start date to be 24 months back from today's date to the start of the month E.g. 01/06/2014

       

      And End Date should be 1 year forwards to the end of the month of the current date. E.g. 31/06/2017.

       

      How can I create these two variables in the script using the current date please?