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 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