Forum Discussion
Advocate IIIHow to make a parameter be today's date
i dont get, why you want to put it in the current value .
i meant go to advanced edior
and change the m code for the following line .
let me know if this helps /
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠:Got it...thank you!! I appreciate the help!
Community Champion
please try this :
EndDateParam = Text.From(DateTime.Date(DateTime.LocalNow()))
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
rmcgrathThank you for the quick response! Unfortunately, I get the following error: DataSource.Error: Microsoft SQL: Error converting data type varchar to datetime.
How do I put that formula into the Parameter editor? I tried the attached screenshot, but it did not work (produced the error above)
- Daniel29195
i dont get, why you want to put it in the current value .
i meant go to advanced edior
and change the m code for the following line .
let me know if this helps /
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠:- rmcgrath
Got it...thank you!! I appreciate the help!