I have the following in a helper class accessed by a Trigger that is run for every Opty given we are using custom Fiscal settings:
String fiscalYear = [SELECT PeriodId, Name from FiscalYearSettings where StartDate<=:curDateEval and EndDate>=:curDateEval].Name;
Which I would like to convert into something like:
List<Date> datesToInclude = new List<Date>();
List<...> fiscalYrs = [SELECT Name from FiscalYearSettings where StartDate<=: IN datesToInclude and EndDate>=: IN datesToInclude]
Adding the "IN" keyword for a in-between date comparison is not working...does someone know how to do this Query in one shot for all my Opty dates?