从字符串“31/7/2018”转换输入'date'无效。 [英] Conversion from string "31/7/2018" to type 'date' is not valid.

问题描述

TxtStartDate.Value = CDate（1 /& Today.Month&/& Today.Year）

TxtEndDate.Value = CDate（Date.DaysInMonth（Today.Year） ，Today.Month）&/& Today.Month&/& Today.Year）

loaddata（）



我尝试了什么：



尝试了一个解决方案但是相同

TxtStartDate.Value = CDate（ 1 /& Today.Month&/& Today.Year）

TxtEndDate.Value = CDate（Date.DaysInMonth（Today.Year，Today.Month）&/ & Today.Month&/& Today.Year）

loaddata（）

但同样的错误

TxtStartDate.Value = CDate("1/" & Today.Month & "/" & Today.Year)
TxtEndDate.Value = CDate(Date.DaysInMonth(Today.Year, Today.Month) & "/" & Today.Month & "/" & Today.Year)
loaddata()

What I have tried:

tried one solution but same
TxtStartDate.Value = CDate("1/" & Today.Month & "/" & Today.Year)
TxtEndDate.Value = CDate(Date.DaysInMonth(Today.Year, Today.Month) & "/" & Today.Month & "/" & Today.Year)
loaddata()
but same error

推荐答案

只需创建一个新的DateTime值并将其传递给SQL：

Just create a new DateTime value and pass that to SQL:

Dim now As DateTime = DateTime.Now
Dim year As Integer = now.Year
Dim month As Integer = now.Month 
Dim day As Integer = DateTime.DaysInMonth(year, month)
Dim dt As new DateTime(year, month, day)

这篇关于从字符串“31/7/2018”转换输入'date'无效。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！