How to define conditional parameters with a combobox that use attribute data containing a date to give predefined date ranges

Hi @DanielStarke  Can you please review my understanding and confirm?

Simply, when we select the “Painting Today” on the top then we need to look into the “schedule Date” and populate the records, which are equal to today’s date right?

if yes, can you please share the XML format of GI here

Yes perfect @Naveen B .

basically in the physical workflow there are two teams, pickers and painters. the pickers are always preparing the material for the painters to work on tomorrow. so we just need “Painting Today” and “Painting Tomorrow” as drop downs and the teams can the focus on what they need to work on

excellent @Naveen B - works perfect other than the part for next week and this week - i wondered if these should be a range somehow? also it would be nice if it showed all until a selection was made in the combo box. would the switch function be better than nested iffs?

=Switch( [TimeDuration] = 'P1', DateAdd( Today(), 'd', 0.5), [TimeDuration] = 'P2', DateAdd( Today(), 'd', 1.5), [TimeDuration] = 'W1', DateAdd( Today(), 'd', 7.5), DateAdd( Today(), 'd', 14.5) , '*') 

i tried to add a wildcard as the closing else but the syntax must not be right

@Naveen B , my subsequent question is linked to this as in I wondered if it would be simpler to have a number of days since the schedule date and then filter against that value for the ranges, rather than use combo box parameters

Hi @DanielStarke  Yeah, switch case is also very simple and here is sample for your reference.

Switch( [TimeDuration] = 'P1', DateAdd( Today(), 'd', 0.5), [TimeDuration] = 'P2', DateAdd( Today(), 'd', 1.5), [TimeDuration] = 'W1', DateAdd( Today(), 'd', 7.5), [TimeDuration] = 'W2', DateAdd( Today(), 'd', 14.5))