saya sudah coba di Query berhasil mas, cuma kl saya pake di VB masih ada eror
ya kursis selalu nunjuk "d"...
ada yg kurang dari scrip dibawah?
cn.Execute ("update t_tagihan Set flag = case " & _
"' when (abs( datediff( "d", tgl_tagihan, getdate() ) ) <= 15) and (status
='Proses') then 'Warning 1'" & _
"' when (abs( datediff( "d", tgl_tagihan, getdate() ) ) <= 30) and (status
='Proses') then 'Warning 2'" & _
"' when (abs( datediff( "d", tgl_tagihan, getdate() ) ) >= 45) and (status
='Proses') then 'Warning 3'" & _
End
rgds,
mc
"Dhani Aristyawan (EDP)" <[EMAIL PROTECTED]> wrote:
New Message Search
Find the message you want faster. Visit your group to try out the improved
message search.
Share feedback on the new changes to Groups
Recent Activity
27
New Members
1
New Files
Visit Your Group
SPONSORED LINKS
Texas driver education
Computer telephony
Christian education
Portable computer
Education
.
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Check out the new improvements in Yahoo! Groups email.
http://us.click.yahoo.com/7EuRwD/fOaOAA/yQLSAA/zCsqlB/TM
--------------------------------------------------------------------~->
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Bagi terjangkit virus lokal, zip virus tersebut
dan kirim ke [EMAIL PROTECTED], kami
akan membuat removalnya untuk anda.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-vb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indoprog-vb/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
