Forum Discussion
Solved
Can i use a common SQL Function in a Power BI importing query
Hi, i'm trying to import data from a MongoDB via ODBC Driver with this SQL Query: SELECT column, NOW() FROM table WHERE orderDate >= DATE_SUB(NOW(),INTERVAL 5 DAY) but the 'NOW()' function re...
Hi Yaotel ,
Does a datetime field exist in your database? if so, try filtering using a field that actually exists in the database table.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
you could try something like this:
declare @now datetime
declare @lastweek datetime
set @now = CAST(getdate() as date)
set @lastweek = CAST(DATEADD(day, -5, @now) as date)
SELECT [column] FROM [table]
where [date] > @lastweek
Regards,
Max
Thank you, but doesn't work
