Im looking to save a file and in the filename I need the previous quarter and year. So if I save the file in January 2021 I need to get Q4-2020 and if I save it in April 2021 I need Q1-2021. Any ideas?
You can dynamically build the file name with a formula tool. I'm pulling today's date as the basis of the quarter.
I'm dynamically changing the file name with the option at the bottom of the output tool.
Great idea - and I suppose if I need the previous quarter I just -1 from the month?
Hello @craigja ,
Another way to solve it:
Regards
Hi @craigja ,
Let me know if this solution helps!!
I have created a customized Master which is very low maintenance and provides high flexibility.
Based on the month that you are running the workflow, I am then assigning the respective Quarter from our customized Master. Then, after concatenating the Current Year with the Quarter, you can use that to add as a Prefix / Suffix to your filename in the output Tool.
You can also Change the Entire filename.
Let me know in case of any query!!
Please mark this as solution if it satisfies your query.
Thanks,
Shreyansh Rathod
Hi @echuong1 , @craigja
Shouldn't the filename be Q4-2020 and not Q4-2021?
Sharing the updated solution here.
Please share your thoughts!!
