Forum Discussion
Power Query with a Date.AddDays
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)
I now understand what you are saying az38
What would be the correct way to only extract dates that are 60 days old?
the best option (from my point of view) is to filter it in SQL-query
the second option is to use filter "In Previous" 60 days in Power Query
and the third option is to use advanced filter in visual filters Pane in the Report mode
I would rather have my query only pull the data needed, instead of pulling everything then filtering. I am trying to be sensitive to our environment and make it less of a load on the database.
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
