Automatic pull of new data based on end date in url power query

[Taher1]

Hello Power BI community, 

I am working on a project that should produce daily dashboards using data from Personio. In order to pull Attendances from Personio, there's a start time and an end time (date parameters) that must be filled. We have done this using Workato. Our goal is to set a start time (for example 2022-05-01) and end time should be the current day so we could automatically pull data from Personio. Is this possible? If so, how? 

Note: I tried setting end time to DateTime.LocalNow() and it didn't work. 

I appreciate your support! 

Best regards

[Vijay_A_Verma · Accepted solution]

It has to be

Date.From(DateTime.LocalNow())