Skip to main content
Question

Is it possible to go back continuously one year from the current date in the StartDate parameter. So that only the past year is in the system?

  • January 18, 2023
  • 2 replies
  • 9 views

jonas.frisc
Level 4
Is it possible to go back continuously one year from the current date in the StartDate parameter. So that only the past year is in the system?

2 replies

sree.c
Level 7
  • Level 7
  • January 18, 2023

Hi Jonas,

step 1: Create a table to generate a date which would be your preferred date.

step 2: In the data pool parameter: select type as dynamic, table where the date is available.

image 

Step 3 : Add this parameter in the extraction to extract only the required records.

 


jonas.frisc
Level 4
  • Author
  • Level 4
  • January 20, 2023

Thank you for the answer, I will test it!