假定生日字段的格式为20140308，可以在项目事件 AfterOpenProject 中写入以下代码即可，打开项目之后 会员表中就会只显示即将过生日的会员。
Dim ids As String
Dim n As Integer = 6 '未来天数,含今天,所以实际是未来7天
For Each dr As DataRow In DataTables("会员").DataRows
Dim s As String = dr("birthday")
s = s.SubString(0,4) & "-" & s.SubString(4,2) & "-" & s.SubString(6,2)
Dim dt As Date = CDate(s)
Dim dt1 As New Date(Date.Today.Year,dt.Month,dt.Day)
Dim dt2 As New Date(Date.Today.AddDays(n).Year,dt.Month,dt.Day)
If (dt1 >= Date.Today AndAlso dt1 < Date.Today.AddDays(n)) OrElse (dt2 >= Date.Today AndAlso dt2 < Date.Today.AddDays(n)) Then
ids = ids & "," & dr("_Identify")
End If
Next
If ids > "" Then
ids = ids.Trim(",")
Tables("会员").filter = "[_Identify] In (" & ids &")"
End If
加好友 
发短信
Post By：2016/3/12 17:07:00 [只看该作者]
