Get Parameter from SQL Query - then pass that Parameter into a different SQL Query

[mmace1]

I'm sucessfully passing a Parameter into my Power Query SQL statements. 

An example of the M code to reference a Parameter:

p.CreateDateUTC >= '"&StartDT&"'

 And the parameter itself:

And I have a query to determine what the StartDT should be:

I can't seem to get my Parameter, to automatically update though.  Instead I just take note of the value, then update the Parameter myself under 'Current Value'

?

[mahoneypat]

Instead of using a parameter, you can have the output of a query to be a text value.  Use your first parameter in a query, create the text string you need, and then use that query instead of the parameter instead of the 2nd parameter.

Regards,

Pat 

[mmace1]

@mahoneypat 

Thanks. 

So for converting my query to text - like this?   I converted to date first (to remove the time portion of the datetime), then converted to text, then drilled down. 



But then, - since my query is all in SQL, I'm not sure how to reference that value in the M Code?? Referencing the Parameter works like this: 

p.CreateDateUTC <'&"EndDT"&'

 But referencing this text value, I'm not clear the syntax? 

[mahoneypat · Accepted solution]

Usually you need a format like YYYY-MM-DD, but get it working with a hard-code value and then reproduce that using Date.ToText( ), if needed.  Then you just reference the query name, not the step name.  In your case,

pCreateDateUTC<" & RevEndDt

If there is more after that, you can concatenate that with & "rest of sql expression"

Regards,

Pat

[mmace1]

Thanks, Date.ToText( ) is what i needed, specifically this format: 

'"&Date.ToText(RevEndDT)&"'