Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Insert Parameter in M language

Hi,   I'm trying to build a Parameterised Query using M Language. I have my variables stored as text fields but when I add them to the final query, it doesnt seem to pick up the string but just ret...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi All,

     

    So after many variations, it turns out it's the same as VBA without spaces. I was building a Paramaeterised Query and wanted a single place to change the value and it update the 6 Queries I have.

     

    The Date value appeared like this "201801", so I created a variable and then managed to insert that using ""&Date&""

     

    All working, thanks for you help. :)

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Can you share the code you have tried? We can use it simply with its name like below.

Insert_Parameter_in_M_language

 

Best Regards,

Dale