VISUAL BASIC DATA SET FULL

The following examples demonstrate possible uses of the DateDiff() function: DateDiff(DateInterval.Year, #, # ) ' one year difference so returns 1ĭateDiff(DateInterval.Month, #, # ) ' one month difference so returns 1ĭateDiff(DateInterval. For example, if the interval is defined as DateInterval.Day and the two dates are a week apart, DateDiff() will return 7. The function returns the difference as the number of specified units. The two date values represent the dates to compared. The interval parameter specifies the unit of time to use when measuring the difference between two date and using the same values as those outlined for the DateAdd() function covered previously in this chapter. The difference between two dates or times can be determined using the Visual Basic DateDiff() function, the syntax for which is: DataColumns serve to constrain a particular value on a DataRow to a type. A DataRow is a collection of values, strings, integers, datetimes etc. It also contains and manages DataRelations A DataTable is a collection of DataRow objects and a collection of DataColumn objects. For example: Format (# 1:02:00 PM#, 'MMMM, d, yyyy, hh:mm') - Returns August, 2, 2007, 01:02įinding the Interval Between Two Dates or Times A DataSet is a collection of DataTable objects. The format styles may be combined in any order to create the desired format. 07)įormat(#, 'yyyy') - returns year as 4 digits (i.e. 7)įormat(#, 'yy') - returns year as 2 digits (i.e. The 'y' character is used to control the formatting of the year: Format(#, 'y') - returns year as 1 digit (i.e. 02 or 12)įormat(#, 'ddd') - returns abbreviated day of week (i.e Tue)įormat(#, 'dddd') - returns unabbreviated day of week (i.e Tuesday) 2 or 12)įormat(#, 'dd') - returns day of month as 2 digits (i.e. Similarly the day of the month may be formatted using the 'd' character: Format(#, 'd') - returns day of month as 1 (day 9) (i.e.

VISUAL BASIC DATA SET FULL

Aug)įormat(#, 'MMMM') - returns full Month name (i.e. 08)įormat(#, 'MMM') - returns abbreviated Month name (i.e. For example: Format(#, 'MM') - returns Month as 2 digits (i.e. The month can be formatted using sequences of 'M' characters. In terms of formatting dates, a number of pre-defined styles are available.

The style parameter defines how the data is to be formatted. The value represents the data to be formatted.

The Format() function uses the following syntax: The Format() function is actually a diverse function that can be used to format various types of data (such as string, monetary values and numbers). For this reason, Visual Basic provides the Format() function to allow the format of the date to be controlled. The default format of the Date and Time in Visual Basic is not always acceptable.

Visual basic data set