Render - Add date from column and next business date

msve

Hello,

I have a workflow that scraps data from WSJ website. I need help with file naming convention. Workflow has a column called timestamp (this is effective date on the WSJ website) which has the date that needs to be the file name. Also, need help with another Business Date calculation.

File name example - “10-26-20 pub 10-22-20 eff”

• The effective date is date shown on the WSJ site  (in this example 10-22-20)
• The published date will be the first business day after the effective date (in this example 10-26-20)

WSJ.yxmd

AngelosPachis

So @msve , from reading your question, I understand that you want to dynamically change the filename of your render to show the published date and effective date in the following format

mm-dd-yy pub mm-dd-yy eff

I've mocked up a workflow that I believe does exactly that. If you are looking published date to be the first Monday in the future, just delete the part in the red box and connect the true output anchor of the filter to the join. Else if you want the next business day to be the next day apart from Saturday and Sunday for example, leave it as is.

Let me know if that helps

Regards

Angelos

WSJ_v2.yxmd