Directory Tool

[suby]

All,

I'm trying to use the Directory Tool to list all the CSV files and then Parsing the Date in the FileDate column as i am able to see all the list of files in both the Directory tool output and the Formula Tool output.

And then I'm trying to filter for current Date and Past 5 months and I'm getting no results on the T filter tool.

Directory Tool
xx xxxxxxxx xxxx_*.csv

FileDate
DateTimePArse(REGEX_Replace([FileName],'.*_(.*)\.csv.*', '$1'),'%Y-%m-%d')

Filter Tool

//current date
toDate([FileDate]) IN( DateTimeToday(),

//First of the current month
toDate(DateTimeFirstOfMonth())

//First of the current month -1
, toDate(DateTimeAdd(DateTimeFirstOfMonth(),-1,'month'))
//First of the current month -2
, toDate(DateTimeAdd(DateTimeFirstOfMonth(),-2,'month'))
//First of the current month -3
, toDate(DateTimeAdd(DateTimeFirstOfMonth(),-3,'month'))
//First of the current month -4
, toDate(DateTimeAdd(DateTimeFirstOfMonth(),-4,'month'))
)

Any help would be much appreciated.

Thanks

[suby]

Hi Binuacs,

As suggested it's working as expected thank you so much.

Thanks