Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

rolling 24 months

Community...I need to put a filter on my Table Input component to read only the last 24 months. I've tried using variables and something like: ${dt.now().add("months", -24)} but it's not working

insight greatly appreciated! :)

5 Community Answers

Matillion Agent  

Ian Funnell —

Hi Brad,

I think ADD_MONTHS might do it, in a Filter component after the Table Input?

ADD_MONTHS(CURRENT_DATE, -24) :: Date

Best regards,
Ian


Brad Sheridan —

Hi Ian...thanks for the quick response. The Filter component now validates but returns now rows. It is setup as follows:
Input Column: postingdt
Qualifier: Is
Comparator: greater than or equal to
Value: ADD_MONTHS(CURRENT_DATE, -24)

Thanks


Brad Sheridan —

Correction:

Value: ADD_MONTHS(CURRENT_DATE, -24) :: Date


Brad Sheridan —

UPDATE:

Nevermind!!! Stupid mistake that I've made....I've got to change the database I'm using as my source! :)


Matillion Agent  

Kalyan Arangam —

Hi Brad,

Thanks for the update. Glad you got it working. I will close this ticket for now.

Best
Kalyan

Post Your Community Answer

To add an answer please login