Can someone please assist me to add the Financial Year to a Date String?
I need it to look at a date entered and return the financial year it falls into:

Of it helps, it will be added to a MoveFile process and to future proof the process, it would be great to have this in place.

Thanks for your help again.
I will be downloading reports each month and filing away into a folder for each month.
So for June, the path would be FY 2019\Jun 19[file name].
For July, it would be FY 2020\Jul 20[file name].

I have the rest sorted, but I cannot do the FY part.

There is another part where I need to add the first month of the FY, but can work that out once I have the logic for FY dates.

The red square is what I need to change due to the FY based on the previous month, and the blue is what I have used to return the month of the report:

I was able to get it to work and to save where I wanted it.
Can I please confirm though that this is returning the year now (ie 2019):
“FY ”+datetime.Now.ToString(“yyyy”)

For the July reports (available in August), I would like it to return FY 2020, and in January it will need to also return FY 2020.

@arivu96 is right. Make sure you calculate the financial year. You will need to do that in another workflow where you send as an argument the current date, and it returns back the period, week, and year.

Typically, a financial year is 13 periods with 4 weeks each and equals 364 days. Then, it will depend on when your year starts. Some companies always start on July 1st. Others (like in the USA) will start on the first Sunday before January 1st. So determine the first day of the current financial year, then you can figure out the last day of that year by adding 364 days, and thus knowing which year the current date lands in.

My head hurts thinking about it though. Maybe someone can help with a calculation. Essentially, if you have Dec 30, 2019 or Jan 1, 2020, you should get back a year of 2020, since the first day for 2020 would be July 1st 2019.

This is working:
"FY "+(Now.Year+if(Now.Month>6,1,0)). ToString()
But it is returning FY 2020.

Apologies if this has been lost in the post, but I need to return the FY of last month.
So for July, I need to financial year of June.
In August, I will need the financial year of July.

I’ve managed to work it out that this is what I need:
"FY "+(Now.AddMonths(-1).Year+if(Now.AddMonths(-1).Month>6,1,0)). ToString()

I think that will work for ever month (December/January included).