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 ""Ta...
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)