Forum Discussion
Power Query with a Date.AddDays
I am trying to write a query when it will only pull dates 60 days older than today, so I dont have to change the query when I refresh it
This is what I have I get the error below
WHERE ""Table"".""Date"" <= Date.AddDays(Date.From(DateTime.LocalNow() as datetime),-60)
This is what I originally had and got no errors
WHERE ""Table"".""Date"" <= TO_DATE ('14-12-2019 00:00:00', 'DD-MM-YYYY HH24:MI:SS')
Error:
DataSourceKind=Oracle
DataSourcePath=reni2.reninc.com
Message=ORA-00936: missing expression
7 Replies
Hi rjs2
it is a Power QUery style and could be use only in Power Query (Advanced editor)
Date.AddDays(Date.From(DateTime.LocalNow() as datetime),-60)It is a SQL-style (PL/SQL in your case) and could be used only in data load step as a part of PL/SQL query statement to extract data from data source
TO_DATE ('14-12-2019 00:00:00', 'DD-MM-YYYY HH24:MI:SS')It's pretty clear for me, if you are trying to use PowerQuery statement in PL/SQL query it won't work
I am doing both in Advanced Editor. The one with TO_DATE works in Advanced Editor, but the Date.AddDays is throwing the error.
Why would I be getting an error with this, whats the correct syntax? The error I am getting is suggesting I have an extra comma or a parenthesis is missing, but I am not.
Date.AddDays(Date.From(DateTime.LocalNow() as datetime),-60)
hey, in the PL/SQL example, it doesnt look like there is a calculation for date, that its hard coded in. Are you saying in a data load (instead of direct query) I can no use a date calculation and I am basically beating my head against a brickwall for nothing
