Is ther a "date type" only contain year and month ?

M

Martin

Is ther a "date type" only contain year and month ? That is, not consider
the date, only consider the year and month.

For example:
I don't want: "2005-04-15"
I want: "2005-04"

Thanks!

Martin
 
J

John Vinson

Is ther a "date type" only contain year and month ? That is, not consider
the date, only consider the year and month.

For example:
I don't want: "2005-04-15"
I want: "2005-04"
Click to expand...

You can *display* a Date/Time using a yyyy-mm format, but under the
hood, it's still a precise date (stored as a double float number).

You might want to consider storing in a 7-character Text field with an
Input Mask of 0000-00.

John W. Vinson[MVP]
 
D

Dirk Goldgar

Martin said:
Is ther a "date type" only contain year and month ? That is, not
consider the date, only consider the year and month.

For example:
I don't want: "2005-04-15"
I want: "2005-04"
Click to expand...

No. There is no "Year/Month" data type. You can use the date/time data
type, only store dates as of the first of the month, and format it to
display only the year and month. But that's likely to be cumbersome.
I'd say you're better off storing separate fields for month and year.
 
M

Martin

Thank you all for the help.

This quetion is generated from inputing the financial statement information.
I only want to indicate the financial statemnet is belong to what month. So
that, I don't want to input any dates, only year and month is enouth.

It's OK. :) I would store it into seperate fields. :)

Thanks again! :)

Martin
 
Top