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

[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

 

[Mike Painter]

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"

See help on formatting dates
"yyyy-mm"

 

[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"

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]

 

[Dirk Goldgar]

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"

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.

 

[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