怎么改变下面日期格式，让月份和天都是两位数，个位数时前面补0.如：2022-08-01
.AddInput("ksrq","开始日期","date").Required = true
.AddInput("jzrq","截止日期","date").Required = true
Dim s3 as date = e.PostValues("ksrq")
Dim s4 as date = e.PostValues("jzrq")
c md.C ommandText ="S elect Count(*) From {V_XS_业务员销量查询} where 客户简称 like '%" & s1 & "%' and 业务员 = '" & DecryptText(e.Cookies("username"),"xxx","xxx") & "' and 开单日期 >= '" & s3 & "' and 开单日期 <= '" & s4 & "'"
messagebox.show(s3)
messagebox.show(s4)
此主题相关图片如下：1.jpg
[此贴子已经被作者于2022/9/1 21:48:40编辑过]
加好友 
发短信
Post By：2022/9/1 21:48:00 [显示全部帖子]
