| 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, "Long Date") | | |
| 47. | Format(datDateTime, "dd mmm yy") | | |
| 48. | Format(datDateTime, "yyyy-mm-dd") | | |
| 49. | Format(datDateTime, "mm dddd hh:mm") | | |