Is it possible to pass a date variable into a variable value (expression)

Matillion ETL
1

Is it possible to pass a date variable into a variable value (expression)

2

Hello,

 

Thank you for your question, can you give us some more information on this please, what are you looking to achieve, where are you trying to put this information etc?

 

Thanks Joe

3

{"expression":{"predicates":[{"attributeName":"trdDate","sign":"=","value":"2020-02-28","valueType":{"dataType":"DATE","fieldFormat":"yyyy-MM-dd"}}]}}

 

the above expression I am passing it as a value to a variable in Matillion, I hardcoded the date value in the expression. But I wanted to dynamically pass the date to the expression, most probably it should be current/sys/server date (excluding week ends and public holidays)

4

Hi Lee,

 

This should be possible using the dt.now() function. You can use the Python component to build the JSON dynamically as part of an orchestration. If that hint does not solve your use case, could you expand further on how the variable is being set? What are you using the variable to do?

 

Thanks and good luck!

 

Brendan