Date Issue in Pipeline Parameter

[amit_saroha]

Hi All,

I have a requirement to pass date in YYYY-MM-DD format and I am using the expression “Date.now().toLocaleDateString()” but I have the below issue.

When I use it in pipeline parameter “Effective_Date” then use _Effective_Date in the pipeline it fails but when I use it directly it works. When I pass something hardcoded in the pipeline parameter it also works e.g. 2022-01-01

Could you suggest what is happening here and what is needed to get it fixed?

Below is not working

Below is working

[amit_saroha]

Can anyone suggest, please?

[amit_saroha]

Hi, can anyone suggest me a workaround, please?

[bojanvelevski]

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_saroha]

bojanvelevski:

eval(_Effective_Date)

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.