How to input a file with one month lag

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

Date Time

Accepted answers

Gumsmenezes

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

All comments

Gumsmenezes

Hi @Oluwapelumi, how does this look?

Solution_V1.yxmd

Oluwapelumi

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

Gumsmenezes

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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703