dim sYear,sMonth,sDay as string
sYear=format(now-1,"yyyy")
sMonth=format(now-1,"m")
sDay=format(now-1,"d")
注释:now是今天的日期和时间,now-1代表昨天的日期和时间,yyyy是年,m是月,d是日
dim sYear,sMonth,sDay as string
sYear=format(now-1,"yyyy")
sMonth=format(now-1,"m")
sDay=format(now-1,"d")
注释:now是今天的日期和时间,now-1代表昨天的日期和时间,yyyy是年,m是月,d是日