Check Last business day logic

[j_]

Hi ,

Am converting a source code into a talend pipeline.

I need to know how we can fetch the last business day in talend..Excluding the weekends ..As of now we no need to consider the holiday list

[Anonymous]

This functionality is not provided out of the box, but you can make use of a Python Processor in your Pipeline to calculate this date. Use a Python Processor like this.....

https://help.talend.com/r/en-US/Cloud/pipeline-designer-processors-guide/performing-multiple-operations-on-customer-records-using-python

To calculate your required logic in Python, you will need to work this out yourself or find an example online representing the logic you need. I quickly found this....

https://stackoverflow.com/questions/2224742/most-recent-previous-business-day-in-python

Not sure if that is exactly what you need, but you could give it a try.

[Antonio69]

Select the cell you will return the previous working day, enter formula =WORKDAY(TODAY(),-1,F2:F4) into the Formula Bar and press the Enter key.

prepaidgiftbalance