Establish a free accounting date report--1.1. Understand several functions about time
1. Understand a few functions about time (Date Expression) Convert date expressions to date type data. A date expression is any expression that can be interpreted as a date, containing a date literal, a string of a date that can be regarded as a date, and a date returned from a function. For example: myDate = CDate("99-5-20") , such date expressions must be double quoted, otherwise the result will be unpredictable. CDate determines the format of the date based on the locale on the system. If the provided format is set with an unrecognized date, the order of year, month, and day cannot be correctly judged. () Returns the date and time set by the current computer system. (Date Expression) Returns an integer representing the year. For example: Year("00-6-15") = 2000 (Date Expression) Returns an integer between 1 and 12, representing a month of the year. For example: Month("00-6-15") = 6 (interval, number, date) Returns a date with a period of time. You can use DateAdd to calculate the date that is thirty days away from today; or calculate the time that is 45 minutes away from now. DataAdd function parameters parameter illustrate interval A string expression is the unit of the time interval to be added. number Numeric expressions are the number of time intervals to be added. Its value can be positive (get the future date) or negative (get the past date). date Date expression, this date also has a time interval. interval parameter setting value value illustrate yyy Year q season m moon y Number of days in one year d day w Number of days of the week ww week h hour n minute s Second for example:
DateAdd("d",10,"2000-6-18") = 2000-06-28
DateAdd("m",-1,"2000-6-18") = 2000-05-18
Related Articles
Solution to the difficulty of access database self-start
After taking the exam these days, I have nothing to do and found that the access database connection errors of the program I started. After starting, I can connect to the database normally by reopening the file.2009-07-07Access uses macro control programs 3. Use conditions in macros
Access uses macro control programs 3. Use conditions in macros...2006-11-11Establish a report on free accounting dates-1.3. Automatically calculate the beginning and end dates based on the dates selected by the user
Establish a report on free accounting dates-1.3. Automatically calculate the beginning and end dates based on the dates selected by the user...2006-11-11Compression and repair methods of ACCESS database files [Pictures and texts]
This page introduces simple compression and repair functions. Online compression is prone to problems, so you can finally implement it locally.2010-11-11Lose weight for your database files
Lose weight for your database files...2006-11-11Access connection data source (ODBC) configuration (must know by novices)
The data source (ODBC) configuration under the management tool in win7 64-bit Ultimate Control Panel is actually only the SQLServer driver, and nothing else is gone. The solution to this problem is as follows2014-07-07Access uses macro control programs 4. Common macro operations
Access uses macro control programs 4. Common macro operations...2006-11-11Establish a free accounting date report--1.1. Understand several functions about time
Establish a free accounting date report--1.1. Understand several functions about time...2006-11-11Access cannot open registry keyword error handling method (80004005 error)
This article introduces the method of handling errors when accessing access prompts cannot open the registry keyword.2013-11-11One sentence SQL updates two tables and can update the corresponding field values in specific implementation
This article uses an SQL statement to update two tables and can update the values of the corresponding fields. The specific implementation is as follows. Friends with similar needs can refer to it. I hope it can help you.2013-05-05