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
