Date Input In A Short Form

[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?

 

[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.

 

[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

 

[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

 

[FARAZ QURESHI]

Thanx John!!!!!

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

Thanx again.

 

[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

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.

 

[MikeR]

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

Re-read *YOUR* post. It said Excel.
Mike

 

[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
'====================================================