This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
Hi,
I am facing the below issue while updating a column using Oracle update snap. Please suggest what I am missing and how this can be corrected.
Extract Effective Date_2022_09_20.slp (10.2 KB)
Hi All,
I have a pipeline date parameter with timestamps and based on this date I am processing some records which I change manually as of now but the requirement is to schedule the pipeline.
I need your help in achieving this date change automatical...
Hi All,
I am running into a strange issue where when I execute the pipeline it completes successfully but when validate it always errors out with the below message. Can you please suggest what is going wrong here and what I should do to correct it? I...
Hi,
I have the below expression but sometimes it can be NULL instead of ‘S’. Could you please suggest how to handle the NULL in the below expression?
$input0.final_document.Pipeline_Status==‘S’ && $input1.final_document.Pipeline_Status==‘S’ && $input...
bojanvelevski:
_Effective_Date == “” ? Date.now().toLocaleDateString() : _Effective_Date
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...
Hello @bojanvelevski,
Sometimes we may have to run the pipeline with old dates due to any issue in our server, network or third-party outages hence I need to pass a date like 2022-11-20, but generally it will be today’s date so I have to use the expr...
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...