Display Date & Time from Date/Time field

Posted on 2004-10-22
Medium Priority
Last Modified: 2013-12-24
I know I have done this before, but I'm in a pinch for a time and don't have time to look for it right now.  I have a field in an Access dbase that displays Date/Time like this "10/22/2004 11:30:35 AM".  On the page, I want to ONLY display it as "10/22 11:30 AM".  I've tried DateFormat and TimeFormat and CreateODBCDateTime but can't get it to be what I want it to be.  Any help???
Question by:Lee R Liddick Jr
  • 2
LVL 21

Accepted Solution

pinaldave earned 500 total points
ID: 12382382
Hi leerljr68,
dateformat(date_time,"mm/dd") adn
timeformate(date_time, "hh:mm tt")
and let me know what is the output and we can debug from there...


Author Comment

by:Lee R Liddick Jr
ID: 12382571
Okay, so I used:  #DateFormat(SubmitTime, "M/D")# #TimeFormat(SubmitTime, "h:m tt")# on my line and that gave me what I wanted.  Thanks pinaldave...I didn't know I just needed to do two separate codes.
LVL 21

Expert Comment

ID: 12382699
Hi leerljr68,
well glad to help you buddy...


Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Suggested Courses

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question