Re: [belajar-access] Mengetahui masa berlaku habis

SELECT dateadd("YYYY",1,date())+1 as SatuThnPlus1Hari

date() ganti dg field tgl terbit...

---

From: Hendro Cahyo <hend_pac@yahoo.co.id>
To: belajar-access@yahoogroups.com
Sent: Tuesday, October 12, 2010 10:38:35
Subject: [belajar-access] Mengetahui masa berlaku habis

 

Yth. Para Suhu Acces

Mohon pencerahan nih.... bagaimana menghitung masa berlaku, misal :
Surat ijin berlaku selama 5 tahun terhitung tanggal terbit, bagaimana cara mengetahui tanggal masa habis berlakunya surat ijin tersebut (format : dd/mm/yyyy)

Terima kasih pencerahannya

__._,_.___

SPAM IS PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___