Timeline for Excluding Dates Using BETWEEN
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 2, 2019 at 13:34 | comment | added | ypercubeᵀᴹ | @Mike you have 2 answers without using CONVERT. Why do you insist on its use? What's the type of the column? | |
| Aug 2, 2019 at 12:42 | history | edited | tbdevmanager | CC BY-SA 4.0 |
edited body
|
| Aug 2, 2019 at 6:27 | comment | added | ypercubeᵀᴹ | The AND should be outside the parentheses, not inside. | |
| Aug 1, 2019 at 20:32 | vote | accept | Daylon Hunt | ||
| Aug 1, 2019 at 20:30 | comment | added | Daylon Hunt | I was initially getting an error related to the "AND", but it was just because the first parentheses should be after the "AND" and not before it. AND (NOT (CONVERT(VARCHAR(10),tm.DATE_CLOSE, 112) BETWEEN @strFirstofMonth AND @strLastofMonth) OR tm.DATE_CLOSE IS NULL) | |
| Aug 1, 2019 at 20:08 | comment | added | Hannah Vernon♦ |
You should add some detail to your answer showing why BETWEEN is terrible for this versus your proposed change.
|
|
| Aug 1, 2019 at 19:15 | review | Low quality posts | |||
| Aug 1, 2019 at 20:35 | |||||
| Aug 1, 2019 at 19:00 | review | First posts | |||
| Aug 2, 2019 at 1:40 | |||||
| Aug 1, 2019 at 18:56 | history | answered | tbdevmanager | CC BY-SA 4.0 |