LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jchartrand

I am using the date of files pulled using the FTP Get node to pull forward certain files into lavastorm. I would like to apply the following rules...

1) Find latest date
2) Find beginning of last month + "X" days (where I am able to adjust "X" within the node)

I have been able to filter for yesterday, as well as all of last month, but am struggling with the more open search terms.

Any help would be greatly appreciated.

Sample dates below.

FileDate
2015-07-16
2015-07-17
2015-07-17
2015-07-18
2015-07-19
2015-07-19
2015-06-23
2015-06-25

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

Hi, Josh, this is a good one. Date adjustments with parameters!

Try the attached. I created a parameter "X" where you can specify the days from last month. If you specify 10, it gives you 2015-07-10.
Attachments:
DateFiltering.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jchartrand

Thanks Roger -

This works well. Just for my understanding, what exactly does the {{^X^}} do in your brg?

Thanks,

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

I've defined a parameter called 'X' in the node. Click on the Declare Parameters button in the node. BTW, you can also do this with a composite and/or at the graph level. The {{^parameterName^}} is the notation you use to call that parameter.