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
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