Forum Discussion

Sgarim4's avatar
Sgarim4
New Contributor II
7 years ago
Solved

Date Filter for loading Excel File

I am trying to filter an excel file from a folder based on date to load onto a database. I have successfully managed to get the filter snap to filter out all months other than current month with the filter code as below,

Date.parse($[‘Update date’]).getMonth()==Date.now().getMonth()

The problem now is i have multiple files for the current month and would like to filter out further to the max of the dates and hence get only one file everytime (currently the above code gets me 2 or more based on current months files).

Thanks for you help.

4 Replies