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 1 JahrFri, May 10, 2024 at 8:47 AM UTC
    • Gemeldet - anzeigen

    .

    • Rafael_Sanchis
    • vor 1 JahrSat, May 11, 2024 at 7:27 AM UTC
    • 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
Anmelden, um zu antworten

Content aside

Kategorien

Alle Themen anzeigen
  • Status Answered
  • vor 1 JahrSat, May 11, 2024 at 7:27 AM UTCZuletzt aktiv
  • 2Antworten
  • 59Ansichten
  • 1 Folge bereits