0

Range Date between two dates and null the other Date

  1. I need the Dates 'Plan 1' to appear between the range of Dates 'Date From' and 'Date to Cutoff',
  2. and the Dates 'Real 1' null
let myFrom := 'Date From';
let myTo := 'Date To cutoff';
select Control where 'Plan 1' >= myFrom or <= myTo and 'Real 1' = null

2 Antworten

null
    • Rafael_Sanchis
    • vor 6 Monaten
    • Gemeldet - anzeigen

    .

    • Rafael_Sanchis
    • vor 6 Monaten
    • Gemeldet - anzeigen

    Share

    let myFrom := 'Date From';
    let myDTC := 'Date To cutoff';
    select Control where 'Plan 1' >= myFrom and 'Plan 1' <= myDTC and 'Real 1' = null
    

Content aside

  • Status Answered
  • vor 6 MonatenZuletzt aktiv
  • 2Antworten
  • 48Ansichten
  • 1 Folge bereits