Date input mask

's Computer Specifications

can anyone tell me what input mask i would use to input:
01/01/07 - 31/01/07
Thanks

's Computer Specifications

On Tue, 27 Mar 2007 15:39:48 -0700, Angel_1 <(E-Mail Removed)>
wrote:

>can anyone tell me what input mask i would use to input:
>01/01/07 - 31/01/07
>Thanks

Into a Text field? Why? It sounds like two Date/Time fields would be more
flexible and more appropriate!

John W. Vinson [MVP]

's Computer Specifications

From your example I hope you are using two seperate one for each date
1. Start date
2. End date

and not 1 field, with two fields it will be easier to sort or filter the
table by date

The input musk for each field will be
99/99/99

and in the format of the field you can use
dd/mm/yy

--
Good Luck
BS"D

"Angel_1" wrote:

> can anyone tell me what input mask i would use to input:
> 01/01/07 - 31/01/07
> Thanks

's Computer Specifications

Thanks
I was only using one field, now i am using two. Alot easier, thanks

"Ofer Cohen" wrote:

> From your example I hope you are using two seperate one for each date
> 1. Start date
> 2. End date
>
> and not 1 field, with two fields it will be easier to sort or filter the
> table by date
>
> The input musk for each field will be
> 99/99/99
>
> and in the format of the field you can use
> dd/mm/yy
>
> --
> Good Luck
> BS"D
>
>
> "Angel_1" wrote:
>
> > can anyone tell me what input mask i would use to input:
> > 01/01/07 - 31/01/07
> > Thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Input mask for date!	justin88	General Software	0	28th Sep 2011 03:53 PM
Input mask date syntax-limit input to a number range	=?Utf-8?B?QmlsbGlhbQ==?=	Microsoft Access Database Table Design	2	18th Nov 2007 03:37 PM
Date format -medium date input mask-French Canadian	=?Utf-8?B?QmlsbEQ=?=	Microsoft Access Forms	5	15th Jul 2007 01:22 PM
date input mask	=?Utf-8?B?S2VsbHk=?=	Microsoft Access	5	5th Oct 2005 10:10 PM
Date input mask	=?Utf-8?B?RGFuaWVsIFA=?=	Microsoft Access Forms	1	9th Apr 2004 09:03 PM