You could certainly accomplish this.
Can you provide a workbook?
In the meantime, you might find this thread helpful:
Basically, the changes to this would be that
- instead of hard-coding the start month integer (7) into the IF clause, you'd put a parameter (or calculated field based on a parameter)
- and then instead of the THEN or the ELSE values that are hardcoded using 7/1 and 6/30, you could make a calculated field that gives the correct "m/d" text string
Hope this helps!
I may be missing something basic here. I was hoping there might be a way to set the field property itself from the parameter. I will take a look at your approach. Since our data sources are generally not very large my backup approach is to create a date field for each of the two additional FY start date option, set the FY start property for each, create a parameter and calculated field to hold the selected field.
Thanks for the help.