Discuss "Date Functions Listed By Name" in the Microsoft Access forum.

Date()
Provides today's date. Date$() gives it as a string.

Day(<date>)
Provides the day of the month (1 .. 31) of <date>.

DateAdd(<interval>,<number>,<date>)
Adds an interval to <date>. The intervals can be anything from seconds to years depending on the value of the <interval> parameter.

DateDiff(<interval>, <date1>, <date2>)
Subtracts <date2> from <date1> and gives the result in the unit specified by the <interval> parameter.

DatePart(<interval>, <datetime>)
Extracts part of <datetime>, for example the minute, week or quarter.

Format(<datetime>, <format>)
Will return <datetime> as a text string in the format specified.

Hour(<time>)
Will return the hour of <time> as a number from 0 to 23.

Minute(<time>)
Will return the minute of <time> as a number from 0 to 59.

Month(<date>)
Will return the month number of <date>.

Now()
Will return the current date and time.

Second(<time>)
Will return the second of <time> as a number from 0 to 59.

Time()
Will return the current time. Time$()gives it as a string.

WeekDay(<date>)
Provides the day of the week as a number from 1 to 7.

Year(<date>)
Will return the year number of <date>.

__________________
If i helped you, make me famous by clicking the