The conversion of a varchar data type to a datetime data type resulted in an out-of-range value #1
Description
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