Crp_Daftar.SelectionFormula = {Data.Tgl} >= date(" + Trim(Year(DTPicker1)) +
"," + Trim(Month(DTPicker1)) + "," + Trim(Day(DTPicker1)) + ") and
{Data.Tgl} <= date(" + Trim(Year(DTPicker2)) + "," + Trim(Month(DTPicker2))
+ "," + Trim(Day(DTPicker2)) + ")
----- Original Message -----
From: "Doni" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, May 16, 2006 11:21 AM
Subject: [indoprog-vb] Tanya Sintax SelectionFormula
Dh. Rekan Rekan VB
saya mau tanya tentang Selection Formula Untuk SelectionFormula Cristal
Report
di VB say memakai
DTPicker1 = Format(Now, "dd-mmm-yy")
DTPicker2 = Format(Now, "dd-mmm-yy")
saya mau menampilkan Data Mulai Tgl>=DTPicker1 dan Tgl<=DTPicker2
Tetapi ada beberapa permasalahan kadang-kadang Data tidak bisa ditampilkan
alias Kosong.Apakah ada cara seleksi yang lain ?
Mohon Bantuannya
Crp_Daftar.SelectionFormula = "year({Data.Tgl}) >= " & Year(DTPicker1) & "
and Month({Data.Tgl}) >= " & Month(DTPicker1) & " and Day({Data.Tgl}) >= " &
Day(DTPicker1) & "'"
'" and year({Data.Tgl}) <= " &
Year(DTPicker2) & " and Month({Data.Tgl}) <= " & Month(DTPicker2) & " and
Day({Data.Tgl}) <= " & Day(DTPicker2) & _
'" and {Data.Pesan}='" & "Y" & "'"
[Non-text portions of this message have been removed]
Untuk berhenti berlangganan kirim email kosong ke :
[EMAIL PROTECTED]
Forum ini berkembang dengan pesat, jika anda memiliki
dedikasi dan waktu, silahkan mengaplikasikan diri
menjadi moderator.
Yahoo! Groups Links
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Forum ini berkembang dengan pesat, jika anda memiliki
dedikasi dan waktu, silahkan mengaplikasikan diri
menjadi moderator.
YAHOO! GROUPS LINKS
- Visit your group "indoprog-vb" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
