Is there an equivalent of network days in datatables? I need to get the data available with a where clause of 2 datediff( less weekend and holidays)
Hope you can help us, thank you in advance!
This question has an accepted answers - jump to answer
I don't think I've heard the term "network days" before - reading about it for Excel, is it "net work days"?
I don't believe SQL has such a function does it, or do you have a function for that already that you can use (i.e. if you were to just make a regular SQL query, how would you do it?).
I want to add the highlighted codes:
to here (see highlighted codes)
OR WHERE 'transaction.id' is equal to some variable. What is that variable? Is it different for every row?
Hi Sir @allan, yes it is different from every row. It was filtered using the for loop and function number_of_working_days.
There are two options then:
Unfortunately it isn't possible to have our Editor server-side libraries perform a query per row (that wouldn't be very efficient anyway).
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.