Improve company productivity with a Business Account.Sign Up

x
?
Solved

Correct formatting for this control source?

Posted on 2011-02-18
2
Medium Priority
?
264 Views
Last Modified: 2012-05-11
Hi there,

What is the correct formatting for this control source?

="Date: " & [Date] & " Time: " & [Time]

I want to add formatting so the date is dd/mm/yyyy & the time is hh:mm:ss

At the moment the current control source returns

Date: dd/mm/yyyy hh:mm:ss & Time: dd/mm/yyyy hh:mm

Thanks

Chris
0
Comment
Question by:smods
2 Comments
 
LVL 9

Accepted Solution

by:
borki earned 1000 total points
ID: 34924789
Are [Date] and [Time] two distinct fields of datatype Date/Time?

="Date: " & Format([Date], "dd/mm/yyyy") & " Time: " & Format([Time], "HH:Nn:SS")

Or is there a single filed and you just want to display it in the above format?

="Date: " & Format([DateValue], "dd/mm/yyyy") & " Time: " & Format([DateValue], "HH:Nn:SS")
0
 

Author Comment

by:smods
ID: 34924803
Two distinct fields my friend!

Thank you very much :)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

607 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