Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Defining today's date on advanced editor

Hey guys,   I'm pulling data out of a POST API, and one of the requested headers is the date period that will be retrieved. Here's what I've got so far:       let url = "https://my.url.co...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , it is checking for numbers

may be like

Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyyMMdd")

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for your response.

 

The following message shows up:

 

 

When I used the code with slashs, I got the following error

Code:
...
Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy/MM/dd")
...

Error message:
“Error parsing comment. Expected: *, got 1. Path 'DtFim', line 1, position 40.”

 

Is it possible to create a function and use this created function into my code? I'm a total newbie on Power Query's M language, so it's just a guess.