DateValue « Date Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Date Functions
  3. DateValue
1.DateValue(date) returns a Variant/Date containing the specified date
2.DateValue("Nov, 23 04") returns 11/23/2004
3.Use the OnTime method to run a VBA procedure on a particular day: runs the DisplayAlarm procedure at 5:00 p.m. on December 31, 2007: