Tuesday, February 22, 2011

Re: [belajar-access] hitung tanggal [1 Attachment]

[Attachment(s) from hari yanto included below]

Audzubillah himinasyaitonirrajim Bismillahirrahmanirrahiim ....,
 
Menurut saya, gunakan DateAdd. Contohnya:
 
Dim jatuh_tempo As Variant
   
    jatuh_tempo = DateAdd("m", 2, "31-Jan-2011")
    'fungsi dateAdd(satuan, jumlah_yang_diinginkan, tanggal_mulai)
    'satuan: m = bulan, d = hari, y = tahun
   
    MsgBox jatuh_tempo
 
-------------
 
Yang dalam bentuk Query, terlampir...
 
Semog bisa membantu dan memberi semangat...
 
Hariyanto (Surabaya)

--- On Tue, 22/2/11, Maulana <maulana_pup@yahoo.co.id> wrote:

From: Maulana <maulana_pup@yahoo.co.id>
Subject: [belajar-access] hitung tanggal
To: belajar-access@yahoogroups.com
Date: Tuesday, 22 February, 2011, 8:58 AM

 
Dear All
 
minta saran donk..
gimana ya...caranya menghitung tanggal jatuh tempo
contoh tanggal terima 01/01/211 jatuh tempo mau dua bulan sehingga jadi 01/02/2011
querynya gimana y?
 
salam


Attachment(s) from hari yanto

1 of 1 File(s)


__._,_.___


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

__,_._,___

No comments:

Post a Comment