Sudah dicoba, dan tidak berhasil, setelah diteliti jam pada tanggalan tersebut berpengaruh, misal ada data dengan tanggal 06/12/2004 14:00:00, maka jika diretrieve dengan :argument1 = 06/12/2004 dan :argument2 = 06/12/2004, maka data tersebut tidak muncul, karena tanggalan data lebih dari tanggalan :argument2, maka untuk mengakalinya saya gunakan DateAdd, saya tambahan 23 jam kedepan (misal :DataAdd(Hour,23,:argument2). Demikian, terimakasih saran semuanya. Salam, Eko Heru Prasetyo [Lemper] System Support MIS Dept, IT Div.
-----Original Message----- From: Allin [mailto:[EMAIL PROTECTED] Sent: 21 Desember 2004 17:09 To: [email protected] Subject: RE: [indopb] Retrieve MS SQL2000 coba dengan convert(char(8), field1, 103) >= :argument1 argument1 : data type string -----Original Message----- From: Eko Heru Prasetyo edp-at-wanaarthalife.com Sent: Tuesday, December 21, 2004 4:54 PM Subject: RE: [indopb] Retrieve MS SQL2000 Saya sudah coba satu persatu, pada awalnya untuk kondisi Field1 >= :argument1 -> data keluar namun setelah saya tambah kondisi ke 2 untuk Field1 <= :argument2 -> data malah tidak keluar Eg : :argument1 = '06/12/2004' :argument2 = '06/12/2004' Salam, Eko Heru Prasetyo [Lemper] System Support MIS Dept, IT Div. -----Original Message----- From: M. Santosa [mailto:[EMAIL PROTECTED] Sent: 21 Desember 2004 16:39 To: [email protected] Subject: RE: [indopb] Retrieve MS SQL2000 Coba cek type date nya ? cocokin dengan yg di database MDY ata DMY .. Coba dulu dengan 1 parameter dengan menggunakan >= stelah keluar baru masukin lagi parameter lainya. -----Original Message----- From: Eko Heru Prasetyo [mailto:[EMAIL PROTECTED] Udah dicoba mas, itu berlaku buat Oracle bukan MS SQL 2000. Salam, Eko Heru Prasetyo [Lemper] System Support MIS Dept, IT Div. IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=12938e0n2/M=294855.5468653.6549235.3001176/ D=groups/S=1705007181:HM/EXP=1103708386/A=2455396/R=0/SIG=119u9qmi7/*htt p://smallbusiness.yahoo.com/domains/> click here <http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group s/S=:HM/A=2455396/rand=503603164> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links CAUTIONARY NOTE: This communication is confidential and privileged and may not be read, copied or disclosed or used by any person other than the stated addressee. Any unauthorized use, copying or disclosure is strictly prohibited and may be unlawful. If you have received this email in error or by mistake, please notify us immediately and delete it from your system. Any confidentiality and privilege of this email is not waived because the email has been sent to you due to such error or mistake. IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=12966h0i7/M=294855.5468653.6549235.3001176/ D=groups/S=1705007181:HM/EXP=1103710000/A=2455396/R=0/SIG=119u9qmi7/*htt p://smallbusiness.yahoo.com/domains/> click here <http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group s/S=:HM/A=2455396/rand=241247110> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/NhFolB/TM --------------------------------------------------------------------~-> IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> 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/
