Foxtable(狐表)用户栏目专家坐堂 → 选取不存在的日期怎么写?


  共有2542人关注过本帖树形打印复制链接

主题:选取不存在的日期怎么写?

帅哥哟,离线,有人找我吗?
有点蓝
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:109505 积分:557193 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2021/1/3 21:57:00 [显示全部帖子]

Dim lst As new List(of Date)
Dim d As Date = Date.Today.AddMonths(-1)
Dim nd As Date = d
Do While d < Date.Today
    lst.Add(d)
    d = d.AddDays(1)
Loop
For Each s As String In DataTables("表A").GetValues("日期","日期 >= #" & nd & "#")
    lst.Remove(cDate(s))
Next
Dim lst2 As new List(of String)
For Each d In lst
    lst2.Add(Format(d,"yyyy-MM-dd"))
Next

Dim cmb As WinForm.ComboBox
cmb = Forms("窗口1").Controls("ComboBox1")
cmb.ComboList = String.Join("|",lst2.ToArray)


 回到顶部