0
Range Date between two dates 'Plan' and null the other date 'Real'
- I need the Dates 'Plan 1' to appear between the range of Dates 'Date From' and 'Date to Cutoff',
- 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
-
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