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?

  • Jan 18, 2023 10:17 AM UTC
  • 2 replies
  • 47 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
  • Jan 18, 2023 10:47 AM UTC

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
  • Jan 20, 2023 9:39 AM UTC

Thank you for the answer, I will test it!