Forum Discussion
- amit_sarohaNew Contributor III
Can anyone suggest, please?
- amit_sarohaNew Contributor III
Hi, can anyone suggest me a workaround, please?
- bojanvelevskiValued Contributor
Hi @amit.saroha,
The values that are passed from parameters, are always a string. So in your case, you’re not passing a function, but a string.
In order your pipeline to work is, either leave the BatchParameter to get the date directly from the pipeline execute like shown on the picture above, or, use the eval() function with the parameter.
eval(_Effective_Date)
That way your function passed like a parameter, will be evaluated and considered as a function.
Hope this helps,
Bojan- amit_sarohaNew Contributor III
Thanks @bojanvelevski - It works but when I pass 2022-11-20 in same parameter instead of expression the eval (Effective_Date) returns 1991 but I need it as it is 2022-11-20.
Please suggest if there is a way to do it, I want both the options working.
- amit_sarohaNew Contributor III
Hi @bojanvelevski, yes, it will be a manual run. I tried the expression you have suggested but it didn’t work. Could you suggest what is wrong what I have done.