Drop Down Question

(0) Share

Report

Posted on by sankhlay

183

Hello All - I have a sitiation with Fiscal Year & Quarter

Based on the date, I would like the drop down value to be the specific Fiscal Year and Quarter. For eg, November 1st is FY 25 Quarter 2. In case the user accesses the form on January 1st 2025, it should show FY 25 Q3. Whats the best way to handle this.

Data Sources is SP List.

Categories:

General Questions

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

mmbr1606 14,558 Super User 2025 Season 2 on at

Like (0)

Report
Drop Down Question

hey

can u try this? its just an idea you might need to tweak that it fits your needs:

Set(varToday, Today()); Set(varFiscalYear, If( Month(varToday) >= 10, Year(varToday) + 1, Year(varToday) ) ); Set(varFiscalQuarter, Switch( Month(varToday), 10, 1, 11, 1, 12, 1, // Q1: Oct-Dec 1, 2, 2, 2, 3, 2, // Q2: Jan-Mar 4, 3, 5, 3, 6, 3, // Q3: Apr-Jun 7, 4, 8, 4, 9, 4 // Q4: Jul-Sep ) ); Set(varFiscalDisplay, "FY " & Text(varFiscalYear) & " Q" & Text(varFiscalQuarter));

in the default of your dropdown set varFiscalDisplay

if it helped please mark as verified answer,

cheers

Was this reply helpful? Yes No