Date Input In A Short Form

F

FARAZ QURESHI

Could there be a way, as in Excel, to insert only 9/9/69, which shall be
automatically be converted to 09-Sep-1969, instead of typing the complete
date?
 
D

Douglas J. Steele

This newsgroup is intended for questions about Access, the database product
that's part of Office Professional.

You'd be best off posting your questions about Excel to a newsgroup related
to Excel.

That having been said, as long as Excel recognizes that what was typed is a
date, you can format it any way you want. In VBA, dates aren't stored with
any particular format: they're eight byte floating point numbers where the
integer portion represents the date as the number of days relative to 30
Dec, 1899, and the decimal portion represents the time as a fraction of a
day.
 
K

Ken Sheridan

Its much the same in Access as in Excel; you set the Format property of the
field in table design, or of a text box control in form design view to:

dd-mmm-yyyy

In Access date/time values are in fact stored as a 64 bit floating point
number with its origin at 30 December 1899 00:00:00. The format property
merely controls how you see the dates.

Bear in mind that a year of or before 29 is treated as 21st century, while
one of 30 or later as 20th century.

Ken Sheridan
Stafford, England
 
J

John Spencer

Yes, you can enter dates like that and have Access automatically interpret
your entry. Do not assign an input mask to the control. Do use a date field
to store the information. You can use a format property to show the date in
any way you desire.

Then you can enter
Jan 1
1 Jan
1/1

And you should have stored in the date field Jan 1 of the current year - that
is Jan 1 2008.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
F

FARAZ QURESHI

Thanx John!!!!!

Never had an idea to check while removing the input mask! The only
encouraging reply in this regard!

Thanx again.
 
F

FARAZ QURESHI

The question did pertain to Access for your kind information! Check out Mr.
Spencer's reply for your knowledge.

--
Best Regards,
FARAZ A. QURESHI


Douglas J. Steele said:
This newsgroup is intended for questions about Access, the database product
that's part of Office Professional.

You'd be best off posting your questions about Excel to a newsgroup related
to Excel.

That having been said, as long as Excel recognizes that what was typed is a
date, you can format it any way you want. In VBA, dates aren't stored with
any particular format: they're eight byte floating point numbers where the
integer portion represents the date as the number of days relative to 30
Dec, 1899, and the decimal portion represents the time as a fraction of a
day.
Click to expand...
 
M

MikeR

FARAZ said:
The question did pertain to Access for your kind information! Check out Mr.
Spencer's reply for your knowledge.
Click to expand...
Re-read *YOUR* post. It said Excel.
Mike
 
J

John Spencer

Well, it is possible that others misread your post. At first I thought
why are you asking an excel question and then realized that you wanted
to know if there was similiar capability in Access.

But I am glad you have a solution for your problem.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Top