Forum Discussion

amit_saroha's avatar
amit_saroha
New Contributor III
3 years ago
Solved

Date Issue in Pipeline Parameter

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...
  • bojanvelevski's avatar
    bojanvelevski
    3 years ago

    When you need to run the pipeline with earlier dates, is it going to be a manual configuration and run?

    You can simply configure the BatchParameterD1 like this:

    _Effective_Date == "" ? Date.now().toLocaleDateString() : _Effective_Date

    That way, if the parameter is not empty, it will be taken into consideration, if it is, than the current date will be generated.

bojanvelevski's avatar
bojanvelevski
Valued Contributor
3 years ago
Copy Link

Tell us more on the use case. You have situation where sometimes the date should be current timestamp and sometimes just a date?

If yes, what is the condition?

You can pass an enhanced expression like :
CONDITION ? Date.now() : '2022-11-20'

and wrap this in eval() in the snap itself.

amit_saroha's avatar
amit_saroha
New Contributor III
3 years ago
Copy Link

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 expression. We don’t care about timestamp only the date in format YYYY-MM-DD.

Also, please help me little more on what you explained in above reply. I am using it as below as of now -

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    3 years ago
    Copy Link

    When you need to run the pipeline with earlier dates, is it going to be a manual configuration and run?

    You can simply configure the BatchParameterD1 like this:

    _Effective_Date == "" ? Date.now().toLocaleDateString() : _Effective_Date

    That way, if the parameter is not empty, it will be taken into consideration, if it is, than the current date will be generated.