79785671

Date: 2025-10-08 16:14:09
Score: 3
Natty:
Report link

With this approach, it's assumed that you have Date dimension table available which is very common. I am providing a snippet of the table that is used for this purpose.

enter image description here

Then create a function which does the job.

Function Code

Call the function by passing any date and it returns the previous bussiness day date.

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Subhraz