VB changes the date format 5 and VB changes the date format

You'd better use 20110809, otherwise 2011111 2011-01-11, 2011-11-01, will disagree. format("20110909",".

format(, "yyyy-mm-dd hh:mm:ss")

Results show 2013-07-22 09:34:47

Dates can be stored as part of real numbers in VB. The number to the left of the decimal point indicates the date: The value to the right of the decimal point indicates the time.

Negative values are before December 30, 1899. So each day can be represented by an integer (0 for 1899-12-30, positive after that day, negative before it), and -657434 2958465 for the legal date of MSVB, i.e. to .

For a given date, you can get an integer for that date with clng(), and conversely, with cdate() you can convert any integer in the -657434 2958465 range to the corresponding date, but the question is, how is it converted?

The Gregorian calendar is a kind of solar calendar, with 365 days in a normal year and 366 days in a leap year, one leap every four years, one less leap every 100 years, and then a leap year in the 400th year, that is, 97 leap years every 400 years. The average length of the calendar year (day) of the Gregorian calendar is only 26 seconds different from the return year (day), and it takes 3,300 years to accumulate only one day.

The following is an analysis of the conversion of years:

function myyear(byval datenum as long) as integer

myyear = 1900 + int((datenum + int((datenum - 15) / 36525) -int((datenum - 15) / 146100 + /

end function

The above ** is completely self-created, but to be honest, I feel that I am also full of food and have nothing to do.

Select the cells on the left first, then copy them to the column on the right, then select the column on the right, right-click, the shortcut menu appears, select "Format Cells", in the window that appears, select the "Numbers" tab, then select "Date", select the corresponding format in the window on the right, OK, and you're good to go!