filmov
tv
How To Format Microsoft Access Date/Time Values to Show the Date Only Unless a Time is Specified
Показать описание
In this video, I'll show you how to format a list of date/time values so that they will show a time if needed, or just show the date value if the time portion is midnight.
Corinne from Henderson, Nevada (a Platinum Member) asks: I built a database where I have a form that shows upcoming appointments and tasks. Some of the appointments have times, which I want to see. However most of items are just tasks that can be done any time that day. If I format the field to show times, they all show up as being at midnight, which doesn't look good. Is there any way to hide the time portion of the date if it's at midnight? Plus, I want to see just hour and minute, not seconds. General Date works, but it shows seconds, and capital AM/PM. I'd like lowercase, if possible.
Silver Members and up get access to an Extended Cut of this video. Members will see how to format a single form date/time field to show the date only unless a time is specified. We'll use a little VBA, the OnCurrent and AfterUpdate events.
Gold Members and up will get a special Double-Extended Cut video. You will see how to format the date/time fields in a continuous form!
SILVER MEMBERS VIDEO:
GOLD MEMBERS VIDEO:
BECOME A MEMBER:
LEARN MORE:
LINKS:
COURSES:
FREE TEMPLATE DOWNLOADS:
ADDITIONAL RESOURCES:
KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, format a date and time field, date/time format, DateOnly function, date without time,
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Corinne from Henderson, Nevada (a Platinum Member) asks: I built a database where I have a form that shows upcoming appointments and tasks. Some of the appointments have times, which I want to see. However most of items are just tasks that can be done any time that day. If I format the field to show times, they all show up as being at midnight, which doesn't look good. Is there any way to hide the time portion of the date if it's at midnight? Plus, I want to see just hour and minute, not seconds. General Date works, but it shows seconds, and capital AM/PM. I'd like lowercase, if possible.
Silver Members and up get access to an Extended Cut of this video. Members will see how to format a single form date/time field to show the date only unless a time is specified. We'll use a little VBA, the OnCurrent and AfterUpdate events.
Gold Members and up will get a special Double-Extended Cut video. You will see how to format the date/time fields in a continuous form!
SILVER MEMBERS VIDEO:
GOLD MEMBERS VIDEO:
BECOME A MEMBER:
LEARN MORE:
LINKS:
COURSES:
FREE TEMPLATE DOWNLOADS:
ADDITIONAL RESOURCES:
KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, format a date and time field, date/time format, DateOnly function, date without time,
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
0:01:05
How to Format Date and Time Values in Access
0:31:07
How to use Microsoft Access - Beginner Tutorial
0:00:59
Format Form Header in Access
0:12:02
Microsoft Access - Tutorial for Beginners in 12 MINS! [ + AI USE ]
0:09:19
Access 2016 - Create a Query Report & Form - How to Make Queries Reports Forms in Microsoft Tuto...
0:04:13
Access: Creating Forms
0:02:48
Microsoft Access 2016 Add Custom Currency Signs and Symbols
0:10:04
How To Format Microsoft Access Date/Time Values to Show the Date Only Unless a Time is Specified
0:59:38
Building with Small Language Models (SLMs)
0:04:29
Access Tutorial - Specifying a range of dates or times
0:11:05
MS Access - Forms Part 1: Basic forms
0:14:09
How To Create Form in Microsoft Access | Form in MS Access
0:01:24
How to add conditional formatting and data bars to reports in Microsoft Access
0:02:18
How to create a simple select query in Microsoft Access
0:04:03
How to RESET AUTO NUMBERS in Microsoft Access | Edcelle John Gulfan
0:25:53
Form Design Aesthetics in Microsoft Access - How to Make Professional Looking Forms
0:03:41
Access 2016 - Subform Tutorial - How To Create Subforms in Microsoft Office 365 - Add Form and Forms
0:04:22
Access: Formatting Reports
0:14:13
How to use Conditional Formatting in Microsoft Access to Color Code Tasks Due Now, Future, Past Due.
0:11:34
Data Entry Form Using MS ACCESS
0:09:38
How to Use Rich Text Formatting in your Microsoft Access Forms & Reports. Color, Fonts, Bold, Mo...
0:09:28
Microsoft Access Short Time Format NO am pm with 12 hour
0:06:06
Access 2016 - Creating Tables - How To Create a New Table in Microsoft MS Design & Datasheet Vie...
0:02:55
Ms Access - Data Type - Number - Format
Комментарии