Solved

Display Date & Time from Date/Time field

Posted on 2004-10-22
125 Views
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???
0
Question by:Lee R Liddick Jr
    3 Comments
     
    LVL 22

    Accepted Solution

    by:
    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...

    Regards,
    ---Pinal
    0
     

    Author Comment

    by:Lee R Liddick Jr
    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.
    0
     
    LVL 22

    Expert Comment

    by:pinaldave
    Hi leerljr68,
    well glad to help you buddy...

    Regards,
    ---Pinal
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
    If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Want to pick and choose which updates you receive? Feel free to check out this quick video on how to manage your email notifications.

    856 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now