ExpressionError re missing module refrence

[abaken]

Hi

I have a query below which calls on a parameterp_StartDate. the parameter has a Date type and format d/mm/yyyy.

I get this error

Expression.Error: The import culture matches no exports. Did you miss a module reference?

The Query code is below.

How can I find where the error is?

= let
Source = GetConsolidatedSQLData("Select accountcode, branchcode, departmentcode, transactiondate, transactionamount, periodno, yearno, periodid from GLTRAN Where GLTRAN.TransactionDate >= '"& Date.ToText(p_StartDate, "d/mm/yy", culture ="en-gb") & "'"),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"AccountCode", type text}, {"BranchCode", type text}, {"DepartmentCode", type text}, {"PeriodNo", type text}, {"YearNo", type text}, {"PeriodID", type text}, {"CompanyCode", type text}, {"TransactionAmount", Currency.Type}, {"TransactionDate", type date}})
in
#"Changed Type"

[Anonymous]

Hi @abaken ,

GetConsolidatedSQLData() is not a built-in function.  Is it a custom function? Please check if this custom function is present in the query. The reason for the error seems to be that this custom function cannot be found in the whole query.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data