Creating Dynamic Parameters in Excel from link to Power Query

Good Evening
Any chance of someone in this group having experience with dynamic parameters. I am trying to use a Month End Date (Dynamic Date) to filter my Power Query (linked from SQL tables from Financial Software). I can hard code it each month but would like to simply enter the date in a table in Excel and it automatically updates my Reconciliation spreadsheets. I get as far as a A Submission Error Message due to the dynamic date field in power query not being in date format in the code relating to the Financial Software. I have watched Excellsfun Youtube channel Video 1349 but it uses Text fields as opposed to date fields. Any direction would be appreciated.

Good night....

Oh, depending on your access level on SQL... Easiest thing to do is to create Stored Procedure, View or Table Valued function and query that in PQ.

Thank you CK76. I will try using this code format: EoMonth = Date.EndOfMonth(DateTime.Date(DateTime.LocalNow())) on Monday. I managed to get the PQ to update my reconciliations sheets using Jan = 1, Feb = 2 etc, but it isn't nice to look at and Accountants like dates..... I added the drop down list, and macro button to update, so pretty amazed with the power of Excel and now PQ.

Much appreciated.

You are welcome
PQ is one of the best features MS added to Excel.

It this solved your question, please mark the thread as solved by using thread tools found at top of your initial post.