Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |