专家坐堂-上月代码怎么写？Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  上月代码怎么写？  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=119996)

--  作者：jolon
--  发布时间：2018/6/5 14:02:00
--  上月代码怎么写？

Dim y As Integer = Date.Today.Year
Dim m As Integer = Date.Today.Month
Dim dt1 As New Date(y, m-1, 1)
Dim dt2 As New Date(y, m-1, Date.DaysInMonth(y, m))

这有局限性呀，如果这月31天就没发显示上月了

--  作者：有点甜
--  发布时间：2018/6/5 15:59:00
--
Dim y As Integer = Date.Today.Year
Dim m As Integer = Date.Today.Month
Dim d As Date = new Date(y,m,1)
Dim d1 As Date = d.AddMonths(-1)
Dim d2 As Date = d.AddDays(-1)
msgbox(d1)
msgbox(d2)