0

Double search

let xSt := 'Date 1';
let xFh := 'Date 2';
let xY := 2024;
select Partidos where Fecha >= xSt and Fecha <= xFh

I have a Multiple Choice with Years ( 2023,2024,2025)

How can integrate the Multiple choice in this search.

3 replies

null
    • Fred
    • 1 mth ago
    • Reported - view

    What kind of field is Year? simple multi choice or dynamic multi choice?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 mth ago
      • Reported - view

       hi Fred is Multiple Choice

    • Fred
    • 1 mth ago
    • Reported - view

    Try:

    let xSt := 'Date 1';
    let xFh := 'Date 2';
    let xY := 2024;
    select Partidos[Fecha >= xSt and Fecha <= xFh and contains(text(Year),text(yearfieldinPartidos))]

    assuming the year field in Partidos is a number.

    you also have to switch to the square brackets [ ] as the where acts funny.

Content aside

  • Status Answered
  • 1 mth agoLast active
  • 3Replies
  • 26Views
  • 2 Following