Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
86
Views
Topic starter
Following 4.13 gives me dates up to yesterday an not today.
I have refreshed the query and it does not update.
Please help.
Thanks
Posted : 04/06/2016 5:53 pm
Hi Moavu,
I refreshed the query in your file attached and also got yesterday's date. That is by design because today isn't over yet.
To change this simply add +1 to the second line of your code:
#"Invoked FunctionSource" = Source(#date(2015, 1, 1), Duration.Days(DateTime.Date(DateTime.FixedLocalNow())-#date(2015,1,1))+1, #duration(1, 0, 0, 0)),
Mynda
Posted : 04/06/2016 9:56 pm
Topic starter
Hi Mynda,
Thanks for that. At least it proved I was attentive. In your video you mentioned it shows "Today's date" that is why I got confused.
Moavu
Posted : 05/06/2016 6:41 am
