3 Replies Latest reply on Oct 18, 2018 11:34 AM by Yuriy Fal

    Automatically changing the date fields every new month

    Kshitij Nagarkar

      Hi Everyone,

      I am having trouble implementing this, so if anyone knows how to do then please do let me know:

       

      I am having 2 date fields:

      1) DW_EXP_DT

      2) DW_EFCV_DT

       

      So right now i have used filter condition for these 2 dates:

      For DW_EXP_DT , its all the days on and after 9/30/2018 (i.e. last day of the previous month)

      For DW_EFCV_DT , its all the days on and before 9/30/2018 (i.e. last day of the previous month)

       

      But its a manual work, as in I will have to change it every month and see the values.

      So is there any way in which I can automate this like "At the start of the new month it will set the DW_EXP_DT to all the days after last day of the previous month and it will set the DW_EFCV_DT to all the days before last day of the previous month"

       

      For example: On 1st November 2018 the DW_EXP_DT field should automatically be set to 10/31/2018 & after   and   the DW_EFCV_DT field should automatically be set to 10/31/2018 & before.

       

      Screenshot:

       

      Please let me know if you have any questions on this.

      Also do let me know this thing.

       

      Thank You,

      Kshitij