date input mask

K

Kelly

I want to input a date as mm/yyyy, I do not want to include a day. Can
someone please post the input mask that I would enter to exclude the day? I
have tried a couple of my own made up things, but it still keeps reverting to
adding the date as 01.

Thank you so much!
 
K

Kelly

No, it's not a text box, it's a date box. I am trying to make a mask for it.
So I guess I need to add to the question what type of Field should I use?
Date/Time or Number?
 
L

ldiaz

Hi Kelly..

perhaps this help you.

InputBox("Report Date:", "Analisis", Format(Date - 1, "dd-mmm"))
ldiaz
 
J

John Vinson

No, it's not a text box, it's a date box. I am trying to make a mask for it.
So I guess I need to add to the question what type of Field should I use?
Date/Time or Number?
Click to expand...

Neither.

A Date/Time value is stored internally as a count of days and
fractions of a day (times) since midnight, December 30, 1899. As such
it ALWAYS has a day component.

A Number field cannot include special characters such as /.

I'd use either two Integer fields for the month and year (don't use
Month or Year as fieldnames though, they're reserved words), or a Text
field with an input mask 00/0000.

John W. Vinson[MVP]
 
Top