date

Date Does not accept null value

by

I am creating a gridview that allows the user to enter the date (example Date of Completion) of a specific artifact (There are multiple). If I try to enter a null or empty value it crashes. I have looked high and low for an answer to this. The data they enter is updated to a sql server database. I have switched the data back and forth between between date and nvarchar. Also, the value has to bind so it updates the database in the ASP.net.

Date returning asp tools?

by

I am trying to build an asp.net web application and I am using SQL Server as my database. So right now I am in a position where I need to have a textbox(or etc.) on my screen, where the users must enter their date of birth… but one thing I require specifically is that this input(?) must return a DateTime value in the C# page. Because the code must see this date and check if this person is older than, say, 18.
First I came up with something like this:

convert varchar to month year format in sql server or javascript

by

I have a ”varchar” like ‘2020-08’ in ”sql” table. I need to convert it like ‘Aug 2020’ to show it in my web page. select convert(varchar,’2020-08′,107) This does not seem to work. Answers: Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue … Read more

Regular expression for asp:RegularExpressionValidator with format MMddyy (leap year issue)

by

We need help for regular expression that work with asp.net asp:RegularExpressionValidator to validate date in MMddyy format. Problem we are facing is leap year. Issue is that is it possible to verify through regular expression that it only accepts valid leap year dates like 02/29/2008 is a valid date but 02/29/2010 is not a valid date.