Low cost ecommerce web development India flash website design
Date Functions
§ Date returns the current date on the server.
§ Time returns the current time on the server.
§ Now returns the current date and time on the server.
§ DateAdd(interval, number, date) is used to add to the date specified
by date. Interval is a string that represents whether you want to add
days, months, years, and so on. Number indicates the number of intervals
you want to add; that is, the number of days, months, years, and so on.
§ DateDiff(interval, date1, date2, firstDOW, firstWOY) is used
to find the time between two dates. DateDiff returns the number of
intervals elapsed between date1 and date2. The optional integer
firstDOW specifies what day of the week to treat as the first. The optional
firstWOY specifies which week of the year to treat as the first.
§ DateSerial(year, month, day) takes the integers year, month, and
day and puts them together into a date value. They may be negative.
§ TimeSerial(hour, minute, second) is similar to DateSerial. Timer
returns the number of seconds elapsed since
§ DatePart (interval, datetime, firstDOW, firstWOY) allows you
to retrieve the part of datetime specified by interval. The optional
integer firstDOW specifies what day of the week to treat as the first. The
optional firstWOY specifies which week of the year to treat as the first.
Date Constants
Value Meaning
yyyy" Year
"q" Quarter
"m" Month
"y" Day of year
"D" Day
"w" Weekday
"ww" Week of year
"h" Hour
"n" Minute
46
"s" Second
Day of the Week Constants
0 vbUseSystem National Language Support API Setting
1 vbSunday Sunday (default
2 vbMonday Monday
3 vbTuesday Tuesday
4 vbWednesday Wednesday
5 vbThursday Thursday
6 vbFriday Friday
7 vbSaturday Saturday
vbUseSystem National Language Support API Setting
vbFirstJan1 Week of January 1
vbFirstFourDays First week with four days of new yea
vbFirstFullWeek First full week
§ Year(date) returns the year portion from date as a number.
§ Month(date) returns the month portion from date as a number.
§ MonthName(date) returns the month portion from date.
§ Day(date) returns the day portion from date as a number.
§ Weekday(date) returns the day of the week of date as a number.
§ Hour(time) returns the hour portion from time.
§ Minute(time) returns the minute portion from time.
§ Second(time) returns the second portion from time.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73