Visual Basic/Date and Time
Date and time functions in Visual Basic are treated here. See also VB6 Command Reference#Date and Time and Snippets#Useful Date Functions.
Some functions:
- Now() - date and time of the present moment
- Day() - day of the month, from 0 to 31
- Year()
- DateValue() - Given a timestamp, returns that timestamp with the time part cleared. Given a string, returns a timestamp with its date portion specified by that string.
- DateNow = DateValue(Now)
- TimeValue() - Given a timestamp, returns that timestamp with the date part cleared. Given a string, returns a timestamp with its time portion specified by that string.
- TimeNow = TimeValue(Now)
- Datepart()
- Timepart()
- Weekday() - 1-7
- If Weekday(Now) = vbSaturday Then MsgBox "It is Saturday."
- WeekdayName()
- Localized name of the week day.
- TodaysWeekdayName = WeekdayName(Weekday(Now, vbUseSystem))
- Works even in non-U.S. locale.
- Month()
- MonthName()
- Hour()
- Minute()
- Second()
- DateAdd()
- Later = DateAdd("d", 31, Now) ' 31 days later
- DateDiff()
- Format()
- Formatted = Format(Now, "yyyy-MM-dd") ' e.g. 2016-09-17
- FormatDateTime()
- Timer()
- IsDate()
Date and Time can be treated as a variables to be read from and written to. However, writing to them changes system date or time, which you usually do not want to do.
Some constants:
- vbSunday = 1, vbMonday, vbTuesday, vbWednesday, vbThursday, vbFriday, vbSaturday = 7
- vbGeneralDate = 0 , vbLongDate, vbShortDate, vbLongTime, vbShortTime = 4
External links
edit- Date Time Functions In Visual Basic, vb6.us
- DateAdd Function - Visual Basic 6.0, chennaiiq.com
- Formating dates and times in VB6, vb6.us
- WeekdayName Function - Visual Basic 6.0, chennaiiq.com
- Finding the Beginning or End of a Week, msdn.microsoft.com
- DateDiff Function - Visual Basic 6.0, chennaiiq.com