Skip to content

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value #1

@SPStuff

Description

@SPStuff

I'm getting this error when starting to process day 13 of month. my date format is dd/MM/yyyy. It seems like a date format issue. I tried some date conversion hacks but I get the same error when I hit day 13.

Exception calling "Fill" with "1" argument(s): "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
At AnalyzeSearchCmdlets.ps1:491 char:17

  •         if ((New-Object System.Data.SqlClient.SqlDataAdapter($q, $store.Data ...
    
  • - CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    - FullyQualifiedErrorId : SqlException
    

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions