How can I change the date format from 12/01/07 to 12-January 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a self taught Access user and have created a Licence and Permit
Database. For Report I require a full date ie 12 January 2007 however, I
also require to measure time with it how can I achieve this? Your help would
be much appreciated. Thanks
 
I am a self taught Access user and have created a Licence and Permit
Database. For Report I require a full date ie 12 January 2007 however, I
also require to measure time with it how can I achieve this? Your help would
be much appreciated. Thanks
Click to expand...

Measure time? Do you mean to also display the time in the control?
05 May 2007 12:35:00 pm
Set the control's format property to:
dd mmmm yyyy hh:nn:ss am/pm
 
Thanks for responding Fred

No, I only want to display the full date (without time) in the Permits or
Licences which I have created in Access and will be handed to the applicants.


When that is done I need to keep track of when it was approved and the
expiry date. If I change the date format will I still be able to create a
query which allows me to use the Between date function? Sorry I must sound
dreadfully ignorant but your help is much appreciated. - Rita
 
Format controls how the data is displayed. It does not control how the data
is stored in the table.

Assuming that the field is a datetime field the data is stored as a number
(type double) where the integer portion represents the date and the decimal
portion represents the time (as a fraction of a day). For instance, Cdbl(#
6/29/2007 09:00:00#) will return 39262.375

So your query should NOT be affected.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I thought as much but that still leaves me with the problem how to change the
date from ie. '1/07/2007' to '1 July 2007' any suggestions?
 
I thought as much but that still leaves me with the problem how to change the
date from ie. '1/07/2007' to '1 July 2007' any suggestions?
Click to expand...

Set the Format property of the Form or Report textbox in which you are
displaying this date/time field to

d mmmm yyyy

John W. Vinson [MVP]
 
Thanks a million I very much appreciated the help - I finally caught on and
it's exactly what I was looking for. - Rita
 
Back
Top