A03- Date format in tables?


S

StargateFan

I was wondering if anyone could help. I googled and found how to show
dates, supposedly, but I haven't gotten anything to work.

I chose long date in the format but I'm not having luck with finding
syntax for the short form for the weekday as nothing comes up in the
many examples there are of date input masks. The long date has the
full day but I need the short form, i.e, Wed instead of Wednesday.

Ultimately, the date should read like this:

Sun Jun 16, 2013

Any help appreciated. I've been googling for a few hours now for
different things and my eyes can't handle any more pages today <g>.

Thanks and cheers.
 
Ad

Advertisements

S

StargateFan

I was wondering if anyone could help. I googled and found how to show
dates, supposedly, but I haven't gotten anything to work.

I chose long date in the format but I'm not having luck with finding
syntax for the short form for the weekday as nothing comes up in the
many examples there are of date input masks. The long date has the
full day but I need the short form, i.e, Wed instead of Wednesday.

Ultimately, the date should read like this:

Sun Jun 16, 2013

Any help appreciated. I've been googling for a few hours now for
different things and my eyes can't handle any more pages today <g>.

Thanks and cheers.
Oh, I should have waited. I had 2 tabs left to look at in my FF and
found what seems to be the answer (I never knew this, but it does seem
to work!!):

-----------------------------
2013-06-16 15:42:00
(http://www.pcreview.co.uk/forums/input-mask-date-t1678393.html)

6th Aug 2003
What you really want is a format, not an input mask. I never put an
input
mask on a date/time field as it gets in the way more than it helps.

Savvy users know that they can enter today's date with 8/6 or 6/8
(depending
on their Regional Settings) - or even using Ctrl-; An input mask would
require more keystrokes.

You are not restricted to the formats presented in the pick list; you
can
set a custom format such as
mmmm d, yyyy

--
Joan Wild
Microsoft Access MVP
-----------------------------

Sure enough! Instead of choosing a format in the first box in the
table's design view (i.e., "General Date", "Long Date", etc.) we just
need to type in the format we want. In this case, mine is this:

ddd.mmm.dd.yyyy

(just like I use in Excel half the time!)

Then I saved the table and sure, enough, all the entries now show in
this format:

Sun.Jun.16.2013.

And when you exit the field format, the date format is displayed as
this:

ddd\.mmm\.dd\.yyyy

Neat. Now I have a way to get what I need each and every time, I
think with regards to date format.

Cheers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top