VB开发报错求助：添加新账单时字符串转Date类型失败

Hey there, let's tackle this date conversion issue you're hitting when adding new bills. The error conversion from string "4/20/2017" to type 'date' is not valid is a classic regional format mismatch problem—here's how to fix it:

Root Cause #

Your code uses CDate(GetLastDayOfMonth) to convert a string to a Date type, but the string format (MM/dd/yyyy, e.g., 4/20/2017 = April 20th) doesn't match your system's regional date settings. For example, if your system uses dd/MM/yyyy (common in Europe), it tries to interpret "20" as a month—which is invalid, hence the error.

Step-by-Step Fixes #

1. Replace CDate with Explicit Date Parsing #

Instead of relying on CDate (which uses system regional settings), use Date.TryParseExact to explicitly define the format of the string returned by GetLastDayOfMonth. This makes your code region-agnostic.

Update line 1054 to something like this:

' First, get the raw string from GetLastDayOfMonth
Dim lastDayString As String = GetLastDayOfMonth
Dim lastDayDate As Date

' Define the exact format your GetLastDayOfMonth returns (adjust if needed)
Dim dateFormat As String = "MM/dd/yyyy"

' Safely parse the string to a Date
If Date.TryParseExact(lastDayString, dateFormat, Globalization.CultureInfo.InvariantCulture, Globalization.DateTimeStyles.None, lastDayDate) Then
    ' Now calculate the due date (keep it as a Date first, convert to string only if needed)
    Dim dueDate As Date = DateAdd("d", 10, lastDayDate)
    ' If you need it as a string, format it explicitly
    Dim dueDateString As String = dueDate.ToString(dateFormat)
Else
    ' Handle the case where parsing fails (e.g., log an error, show a user message)
    MsgBox("Invalid date format returned from GetLastDayOfMonth: " & lastDayString)
End If

2. Audit the set_CutoffDates Code Block (Line 1102) #

The error stack points here too, so this block likely uses the same unsafe CDate conversion. Apply the same TryParseExact approach here to ensure all date conversions use explicit formatting.

3. Bonus: Return Date Types Directly (If Possible) #

If you can modify the GetLastDayOfMonth function to return a Date type instead of a string, you'll eliminate the conversion step entirely—this is the cleanest solution, as it avoids string-date back-and-forth.

Key Takeaway #

Never rely on implicit date conversions (like CDate) when working with date strings that have a fixed format. Explicit parsing ensures your code works consistently across different regional settings.

内容的提问来源于stack exchange，提问作者Mohamed Al-A'anesi