Tag: Date Time
-
asp.net | Function to convert date from UK to USasp.net |
I created a function and I call it whenever there is a date value, as the default date format for SQL database is yyyy-mm-dd Simply import the class feed it with the date you would like to convert New Function The Function code (old code / it has few bugs when there are multi culture…
-
asp.net | Calendar out of range?!
Today I have received the following message while creating a user details page: Specified time is not supported in this calendar. It should be between 04/30/1900 00:00:00 (Gregorian date) and 11/16/2077 23:59:59 (Gregorian date), inclusive.Parameter name: time I understand what causing the problem is an Arabic calendar (Hijri) is being used for (Gregorian) calendar. Still…
-
asp.net | Date conflict mm/dd
In our region we use the UK format for dates (dd/mm) however, the SQL database default time line is US (mm/dd), that could create problems while inserting dates into the database. To solve this issue, in SQL Server Management studio Add the following code in web.config