| Author |
 Topic  |
|
|
calvinkwoo3000
Yak Posting Veteran
Singapore
88 Posts |
 Posted - 03/22/2012 : 00:04:09
|
Dear expertise and admin,
how do i sum a datediff with minus out the weekend(saturday and sunday).
thank you. |
|
|
khtan
In (Som, Ni, Yak)
Singapore
16745 Posts |
Posted - 03/22/2012 : 00:06:24
|
Best is you have a calendar table. Then you can also exclude public holiday etc
KH
Time is always against us
|
 |
|
|
calvinkwoo3000
Yak Posting Veteran
Singapore
88 Posts |
Posted - 03/22/2012 : 00:09:11
|
quote:
Originally posted by khtan
Best is you have a calendar table. Then you can also exclude public holiday etc
KH
Time is always against us
khtan, yes i have a holiday table,
how do i able to minus it together?
our holiday is declare from and to date... |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16745 Posts |
Posted - 03/22/2012 : 00:15:49
|
if you don't have a calendar table, it is worth while to create one. It make things much easier.
If you don't have one, you can consider MVJ's F_TABLE_DATE
KH
Time is always against us
|
|
|
|
calvinkwoo3000
Yak Posting Veteran
Singapore
88 Posts |
Posted - 04/02/2012 : 05:33:40
|
quote:
Originally posted by khtan
if you don't have a calendar table, it is worth while to create one. It make things much easier.
If you don't have one, you can consider MVJ's F_TABLE_DATE
KH
Time is always against us
Mr khtan,
Yes, i copy the whole code and run it once....
do i need to run it for every database or no need? |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16745 Posts |
Posted - 04/02/2012 : 05:35:54
|
yes. You need to run it for every database that you required this function
KH
Time is always against us
|
|
|
| |
Topic |
|
Sum datediff with minus weekend
