DateSerial
Using the DATESERIAL Function
In this tutorial you will learn how to use the DateSerial Function.
The DateSerial function returns a Date for a specified year, month, and day.
=DateSerial( year, month, day )
year a number between 100 and 9999
month any numeric expression (1-12)
day any numeric expression (1-31)
The result is 02/11/2012.
UK Date Format
 FORM
In a Form you could set the Default Value of a Textbox to
=DATESERIAL(2012, 11, 2)
 VBA
In a Form add a TEXTBOX control and rename it "txtDateSerial", then you could add the following in the Load Event.
Private Sub Form_Load()
txtDateSerial = DateSerial(2012, 11, 2)
End Sub
Course
Want to learn more? Request this via the contact form.
Seminars
Access Payables
|
Access SQL 2
Tips
See this FREE Tip on DateSerial.
 Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
| 
