SELECT [test]
from table.report
where 20200611 between date_start and date_end
Does anyone know how to do this....I need to make this 20200611 dynamic so it's always the current Monday of the week in this date format.
Nevermind, this one should do:
SELECT [test]
from table.report
where convert(varchar, getdate(), 112) between date_start and date_end
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
175 | |
67 | |
66 | |
55 | |
55 |
User | Count |
---|---|
183 | |
103 | |
90 | |
75 | |
70 |