Everytime i saved the date into table after i read it by advanced excel its saved the default value "1900-01-01"
in Excel i have dates
In outsyetm entity Table it saved the default value !!
whats the solution ?
even format is not working as well
TextToDate(FormatDateTime(TextToDate(PONeedDate), "dd/MM/yyyy"))
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Locale: en-USDateFormat: yyyy-MM-ddPID: 9932 ('w3wp', Started='9/13/2022 12:47:15 PM', Priv=758Mb, Virt=2111115Mb)TID: 131Thread Name:
ReadExcelFile System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.