By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Date input mask.

P: n/a
Greetings all...

I need to be able to input dates into a table in the following format:

Saturday/29/October/2005

Could someone please tell me the input mask for this?

I'm using Access 2002.

Ta...
ChipShop
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
chipshop wrote:
Greetings all...

I need to be able to input dates into a table in the following format:

Saturday/29/October/2005

Could someone please tell me the input mask for this?

I'm using Access 2002.

Ta...
ChipShop


Dates are always stored exactly the same. Formatting and InputMasks only affect
how you see them and how you enter them and InputMasks are a big PITA. My
advice is let the users enter the date any way they want and use the format
property to make it display the way you want.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
Dates aren't stored with any particular format: they're 8 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).

Once you've got the dates in the table, you can display them however you
want by using the Format property. For what you want, you're looking for a
format of dddd\/dd\/mmmm\/yyyy

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"chipshop" <ejgn@*remove*gmx.net> wrote in message
news:dk**********@news7.svr.pol.co.uk...
Greetings all...

I need to be able to input dates into a table in the following format:

Saturday/29/October/2005

Could someone please tell me the input mask for this?

I'm using Access 2002.

Ta...
ChipShop

Nov 13 '05 #3

P: n/a
chipshop <ejgn@*remove*gmx.net> wrote in
news:dk**********@news7.svr.pol.co.uk:
Greetings all...

I need to be able to input dates into a table in the following
format:

Saturday/29/October/2005

Could someone please tell me the input mask for this?


NO!!!!!

Dates are stored in the tables as a double precision number.

You want instead to FORMAT the appearance of the date, after it has
been entered.

Put this in the format property of the textbox or field
dddd\/dd\/mmmm\/yyyy
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #4

P: n/a
Thank you all for your replies!

Problem solved.

ChipShop

"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135...
chipshop <ejgn@*remove*gmx.net> wrote in
news:dk**********@news7.svr.pol.co.uk:
Greetings all...

I need to be able to input dates into a table in the following
format:

Saturday/29/October/2005

Could someone please tell me the input mask for this?


NO!!!!!

Dates are stored in the tables as a double precision number.

You want instead to FORMAT the appearance of the date, after it has
been entered.

Put this in the format property of the textbox or field
dddd\/dd\/mmmm\/yyyy
--
Bob Quintal

PA is y I've altered my email address.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.