[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

656 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