topic Re: Check Last business day logic in Archived Discussions

Check Last business day logic

j_ — Thu, 08 May 2025 17:40:29 GMT

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

Re: Check Last business day logic

Anonymous — Wed, 10 Nov 2021 11:17:49 GMT

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.

Re: Check Last business day logic

Antonio69 — Tue, 21 Jun 2022 06:11:26 GMT

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