Kenapa ga dicoba buat form tambahan aja,tp khusus buat memuat hari libur aja,kl dah kaya gitu,kan nanti tgl jalanin ky biasa aja tuh.... Saya pernah liat ko yg pernah buat,die buat ngitung jmlh hari kerja,ikut dimilis ini jg ko orgnya,cb aja diminta..
--- Sistyo Alfan <[EMAIL PROTECTED]> wrote: > halo.. > > kalau fungsi standard mungkin gak ada / saya blm > nemuin. tapi coba bikin user defined function... > kira-kira scriptnya spt ini : > > --jumlah sabtu/minggu > declare @intSatSun integer > --tanggal awal > declare @dtBegin datetime > --tanggal akhir > declare @dtEnd datetime > --tanggal untuk looping > declare @dtCurrent datetime > --jumlah selisih hari > declare @intDateDiff integer > > set @dtBegin = getdate() --11 november > set @dtEnd = @dtBegin + 4 -- 15 november > set @dtCurrent = @dtBegin > set @intSatSun = 0 > while (@dtCurrent <= @dtEnd) > Begin > if ((datepart(dw,@dtCurrent) = 1) or > (datepart(dw,@dtCurrent) = 7)) --jika sabtu / minggu > begin > set @intSatSun = @intSatSun + 1 --increase > jumlah sabtu/minggu > end > set @dtCurrent = @dtCurrent + 1 > end > set @intDateDiff = datediff(d,@dtBegin,@dtEnd) - > @intSatSun > print @intDateDiff -- output = 2 > > > kalau mau dijadikan function, @dtBegin dan @dtEnd > bisa dijadikan parameternya.. > mudah2an bermanfaat > ----- Original Message ----- > From: Lusi Sulittyowati > To: [email protected] > Sent: Friday, November 11, 2005 11:24 AM > Subject: [Programmer-VB] menghitung selisih hari > tanpa sabtu dan minggu di sql server 2000 > > > halo temen temen programmer... > > nchee mau tanya nih.. boleh gak ? > > gimana ya caranya, menghitung selisih hari 2 buah > tanggal di sql server tapi sabtu / minggu nya gak di > itung. > > contohnya gini, menghitung selisih hari dari > tanggal 11 november sampai dengan tanggal 15 > november berarti cuma 2 hari, karena sabtu / dan > minggunya gak di itung > > > > mohon pencerahannya... > > > > nchee > > ( newbie in programmer :D ) > > > > > > ------------------------------------------------------------------------------ > Yahoo! FareChase - Search multiple travel sites in > one click. > > Untuk keluar dari millis ini, kirim email kosong > ke: > [EMAIL PROTECTED] > > > > > > SPONSORED LINKS P rogrammer In donesia Basic > programming language > Computer programming languages Programming > languages Java programming language > > > ------------------------------------------------------------------------------ > YAHOO! GROUPS LINKS > > a.. Visit your group "Programmer-VB" on the > web. > > b.. To unsubscribe from this group, send an > email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > ------------------------------------------------------------------------------ > > __________________________________ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/k7folB/TM --------------------------------------------------------------------~-> Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
