I'm trying to update a Text Label to calculate the current fiscal year, as well as one for the past fiscal year. The form as rich text entries, and one of the text boxes asks for info on the current fiscal year, another asks about progress completing left over goals from the past fiscal year. Our fiscal year is July 1 to June 30.
I'm a SharePoint person by trade, Power Apps is new to me. This is the formula I wrote for a calculated column for current fiscal year: =IF(MONTH(Created)>6,"FY"&TEXT(Created,"yy")&"/"&RIGHT(YEAR(Created)+1,2),"FY"&RIGHT(YEAR(Created)-1,2)&"/"&TEXT(Created,"yy")). The result is FY 23/24
I got as far as posting the current year in Power Apps, but I cannot figure out the way to code years.
Any help is appreciated.
Here you go:
If(
Month(Today()) > 6,
"FY" & Text(DateAdd(Today(), -1, TimeUnit.Years), "yy") & "/" & Text(Today(), "yy"),
"FY" & Text(DateAdd(Today(), -2, TimeUnit.Years), "yy") & "/" & Text(DateAdd(Today(), -1, TimeUnit.Years), "yy")
)
@SpongYe Thank you so much, it worked perfectly!
By any chance could you help me update it to be also for the last fiscal year? I tried modifying what you wrote, I got it to say 22/24, but looking to also have 22/23.
Hi @ObiRickC137
This is a example of the current fiscal year:
If(
Month(Today()) > 6,
"FY" & Text(Today(), "yy") & "/" & Text(DateAdd(Today(), 1, TimeUnit.Years), "yy"),
"FY" & Text(DateAdd(Today(), -1, TimeUnit.Years), "yy") & "/" & Text(Today(), "yy")
)
If you have any questions or feedback, please let me know. Have a great day! 😊
-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]
I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,089
Most Valuable Professional