topic Year calculation based on selected date in App Development

Year calculation based on selected date

Kaushik2020 — Sun, 17 Aug 2025 06:11:59 GMT

I have a scenario where i want to show the text label based on the below scenario. Please suggest.

Year	Quarter
2024	Q1
2024	Q2
2024	Q3
2024	Q4
2025	Q1
2025	Q2
*2025*	Q3

here we have 4-Quarters data for 2024 and 3-Quarters for 2025.

1. If the user selects Year as 2024, i should see the text label as 2024-Q4 as the max in Year 2024 is Q4.

2. Approved data for 2025 we have till Quarter 2 only. i should see text label as 2025-Q2.

Thanks in advance.

Re: Year calculation based on selected date

Amit_Prajapati — Sun, 17 Aug 2025 15:30:30 GMT

We can use the MaxString() function here.
When a user selects a year—like 2025

it will return the highest quarter for that year.

For example, if all quarters (Q1 to Q4) are available for 2025, it will show 2025 Q4 using this expression: =[_Fiscal Year] & ' ' & MaxString([Fiscal Quarter])

If I select Fiscal Year 2026 it will return Q2

Let me know if it's working in you case or not.

Re: Year calculation based on selected date

Vegar — Mon, 18 Aug 2025 12:26:18 GMT

You could pre-format a dual field for year quarter in the script.

LOAD

Dual(Year&'-'&Quarter ,Year&right(Quarter,1)) as Year_Quarter,

inline [

Year Quarter

2024 Q1

2024 Q2

2024 Q3

2024 Q4

2025 Q1

2025 Q2

2025 Q3

](delimiter is ' ');

Then you could just use =maxstring(Year_Quarter) to fetch and present the lates year quarter value in your selection.