Forum Discussion
diskovered
Helper III
Helper IIImonday WHERE in PowerBI
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.
1 Reply
diskoveredNevermind, this one should do:
SELECT [test]
from table.report
where convert(varchar, getdate(), 112) between date_start and date_end