How to input a file with one month lag

[Oluwapelumi]

I have a workflow where I am trying to input files with one month lag. For example, if I am working on a report for Aug Month End, the input file available is for July Month End. How do I use the formula & dynamic input tool to bring in this file?

Thanks,

Pelumi

[Gumsmenezes]

Hi @Oluwapelumi, how does this look?

[Oluwapelumi]

Thanks! How do I edit this to only pick a week day and not weekends?

[Gumsmenezes · Accepted solution]

You can use the formula DateTimeFormat([Date],"%A") to create a new field and then filter out "Saturday" and "Sunday" using the filter tool.