Format(datDateTime, "Long Date") : Date Format « Date Functions « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Date Functions » Date Format 




Format(datDateTime, "Long Date")
 
Sub dateFormat1()
    Dim datDateTime As Date
    datDateTime = #11/30/1998 10:54:17 AM#
    Debug.Print datDateTime
    Debug.Print format(datDateTime, "Long Date")
End Sub

 
Related examples in the same category
1.Format the date type value
2.Format time as mmmm_yyyy
3.formatting the date and time with format function
4.Using the Format Function to Format an Expression: Format(expression[, format[, firstdayofweek[, firstweekofyear]]])
5.: - Time separator (typically a colon, but this depends on the locale).
6./ Date separator (also locale-dependent).
7.c - Displays the date
8.d - Displays the date (1 to 31) without a leading zero for single-digit numbers.
9.dd - Displays the date with a leading zero for single-digit numbers (01 to 31).
10.ddd - Displays the day as a three-letter abbreviation (Sun, Mon, Tue, Wed, Thu, Fri, Sat) with no period.
11.dddd - Displays the full name of the day.
12.ddddd - Displays the complete date (day, month, and year) in the system's short date format.
13.dddddd - Displays the complete date (day, month, and year) in the system's long date format.
14.aaaa - Displays the full, localized name of the day.
15.w - Displays an integer from 1 (Sunday) to 7 (Monday) containing the day of the week.
16.ww - Displays an integer from 1 to 54 giving the number of the week in the year.
17.m - Displays an integer from 1 to 12 giving the number of the month without a leading zero on single-digit months.
18.mm - Displays a number from 01 to 12 giving the two-digit number of the month. When used after h returns minutes instead of months.
19.mmm - Displays the month as a three-letter abbreviation (except for May) without a period.
20.mmmm - Displays the full name of the month.
21.oooo - Displays the full localized name of the month.
22.q - Displays a number from 1 to 4 giving the quarter of the year.
23.y - Displays an integer from 1 to 366 giving the day of the year.
24.yy - Displays a number from 00 to 99 giving the two-digit year.
25.yyyy - Displays a number from 0100 to 9999 giving the four-digit year.
26.h - Displays a number from 0 to 23 giving the hour.
27.Hh - Displays a number from 00 to 23 giving the two-digit hour.
28.N - Displays a number from 0 to 60 giving the minute.
29.Nn - Displays a number from 00 to 60 giving the two-digit minute.
30.S - Displays a number from 0 to 60 giving the second.
31.Ss - Displays a number from 00 to 60 giving the two-digit second.
32.ttttt - Displays the full time (hour, minute, and second) in the system's default time format.
33.AM/PM - Uses the 12-hour clock and displays AM or PM as appropriate.
34.A/P - Uses the 12-hour clock and displays A or P as appropriate.
35.AMPM - Uses the 12-hour clock and displays the AM or PM string literal defined for the system.
36.For example, the following statement returns Saturday, April 01, 2006:
37.format(Now, "d-mmm-yy")
38.format(Now, "d-mmmm-yy")
39.format(Now, "mmmm d, yyyy")
40.format(Now, "ddd")
41.format(Now, "dddd")
42.format(Now, "ddddd")
43.format(Now, "dddddd")
44.Format(Now, "Hh:Nn:Ss AM/PM")
45.Format(Now, "ttttt")
46.Format(datDateTime, "dd mmm yy")
47.Format(datDateTime, "yyyy-mm-dd")
48.Format(datDateTime, "mm dddd hh:mm")
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.