How to verify that the date entered is valid date 5

I found it troublesome to watch, if you want to use the real-time date, use the timer control.

There is also a use of three text text boxes, the first one is the year, the second is the month, and the third is the date, and then check, the check method is as follows, and then use the "&" to string together.

In there is an idea for you, I don't have time to write ** by myself, and ** can't be small, the first is to use the string lookup, to find the two characters "-" bit, as above is l=5 and k=7 to determine the character length q=9

If the first digit of "-" is not 5, then the year is wrong.

The second step is to confirm whether the year is a leap year, if there is a **, you can find it yourself.

The third step is to confirm that it is the month of the middle year, i.e., s=mid(string, l+1, k-l-1).

Determine what the month is, and then figure out its maximum value.

Finally, there is the date of interception. s=mid(string, k+1, q-k).

Then it's time to see if the date is at the maximum of the month. Hehe, it's very troublesome, and in the end it's to write such a ** in a sub or function process, so that the call is simple.

It's better to write it yourself, so you can have pride. Rattle.

The function to check the valid date isdate (a character expression), for example, isdate("2008-2-31")=falseisdate("2008-2-28")=true you can use this function to modify your key**!

First of all, it is recommended that you use the dtpicker control.

Second, if you have to use the text control, you can use isdate("Your value"), the return value is a Boolean type.

mm = month, yy = year. For example, the demolition of Shen 07 15 is July 2015.

1. For this kind of software related to property security, go directly to the official website of China Construction Bank, enter the homepage and find the mobile version of the client software in the center, install and open it, and pop up a sharing prompt.

2. Enter the main interface of the software, click on the upper left manuscript corner: "Login", and log in.

3. Here, if you open a mobile banking before, click directly: "Login".

4. Enter the mobile phone number to be registered, the mobile phone number when activating, the first time you need to authorize the device, only allowed to use on this mobile phone. Click "Login" to successfully log in to use the software's features.

mm = month, yy = year. For example, 07 15 is July 2015.

2. Enter the main interface of the software, click "Login" in the upper left corner, and log in to the account.

3. Here, if you have opened mobile banking before, click directly: "Login".

4. Enter the mobile phone number to be registered, the mobile phone number when activating, the first time you need to authorize the device, only allowed to use on this mobile phone. Click "Login" to successfully log in to use the software's features.

There is a valid date on the back of the ID card and fill in the following group directly:

For example: expiration date: April 23, 2011 - April 23, 2021, just write the back of April 23, 2021, and choose the long-term directly, no need to fill in the date.

If the input format is incorrect, enter according to the validity period of the ID card.

The following methods can be used to determine whether the date constant entered is correct

1) If the cell has not been formatted (it is regarded as regular by default), the correct date constant should be right-aligned (next to the right border of the cell).

2) Check the column: If the column shows the style of keyboard input, excel does not interpret it as a date value; If the column shows the date style, then Excel interprets the date correctly.