How can I get yesterday date using ataccama expression
You can use the following expressions depending on your use-case:
* dateAdd(today(),-1,'DAY') * dateAdd(now(),-1,'DAY')
The first one will give you back the current date minus 1 day in YEAR-MONTH-DAY format, whereas the 2nd one will be in the YEAR-MONTH-DAY HOUR:MINUTE:SECOND.
It is up to you to tailor the expression to your unique needs. I hope this information helped you with your inquiry.
Thank you so much for your reply.I will surely try this