0

Range Date between two dates 'Plan' and null the other date 'Real'

  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 myDTC := 'Date To cutoff';
select Control where 'Plan 1' >= myFrom or <= myTo and 'Real 1' = null

1 reply

null
    • Fred
    • 5 mths ago
    • Reported - view

    You don't want an 'or'. It should be an 'and'. Plus you are missing a second 'Plan 1' after the or. You use the variable myTo, but you don't define it any where.

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

    You may not need the 'Real 1' = null since changing the 'or' to 'and' will remove DK-0002.

Content aside

  • Status Answered
  • 5 mths agoLast active
  • 1Replies
  • 23Views
  • 2 Following