Format Date Values to Show Time Only if 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.

Members

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

•  Extended Cut Video - Silver
•  Double Extended Cut Video - Gold
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Calculated Fields: https://599cd.com/Calculated
• IIF Function: https://599cd.com/IIF
• Field Properties: https://599cd.com/ACB3
• Custom Date Formats: https://599cd.com/ACX3
• Intro to VBA: https://599cd.com/IntroVBA
• AfterUpdate Event: https://599cd.com/AfterUpdate
• OnCurrent Event: https://599cd.com/OnCurrent

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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