Calculating business days

Lonnie.Hull

Hello,

I'm attempting to calculate the number of business days (Monday-Friday) that are in my data. I have a column that shows the order date, and I want to show how many work days it's been since that date.

I've searched through the site, but I don't believe that anyone has asked about this before.

Can it be done using dataTables, or do I need to do this at the SQL side?

Thanks,

kthorngren

You can create a column for "Work Days" then use columns.render to perform the calculation from the row data and populate in that column.

Kevin