How to make a parameter be today's date

[rmcgrath]

I have created two parameters:

StartDateParam = 1/1/2022

EndDateParam = 3/5/2024

I have the following M code to pull in a stored procedure into Power BI:

let
     StartDate = Text.From ( StartDateParam ),
     EndDate = Text.From ( EndDateParam ),
     Source = Sql.Database("S-DB2-VMC\VERSOVA_PROCDATA", "EggProcPlant_Test",
     [Query="EXECUTE [dbo].[sp_Gp_GrdEggSalesComb]#(lf) @Startd = '" & StartDate & "'#(lf) , @Endd = '" & EndDate & "'"])
in
     Source

Works great...however, I would like to have the EndDateParam always use today's date so I don't have to manually update the parameter each time.  How would I do that?

[Daniel29195 · Accepted solution]

@rmcgrath 

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! 🤠:

[Daniel29195]

@rmcgrath 

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! 🤠

[rmcgrath]

Thank 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 · Accepted solution]

@rmcgrath 

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 · Accepted solution]

Got it...thank you!!  I appreciate the help!