Table, form etc... Data Type

[Guest]

Is there any way to create a new Date/Time Data Type that would include only
the month & year so that when I create an Excel pivot table and want to
filter for only certain months that are not year spacific, that Excel only
see's the month or year or both, but not the day or time? The filter criteria
I need to use for the Pivot Table is semi annual, non-year specific. I am
concerned only with the months involved.

Thanks
rogerw99

 

[Guest]

Both Access and Excel store DateTime as a decimal number. The whole number
part is the number of days since at point in time like midnight 1900. The
decimal fraction of the number is the part of a day - 0.5 is half a day or 12
noon - 0.25 is 6 am.
The only difference in what you see is the FORMAT. Just set the format in
your form or report to what you want. For year it uses "yyyy" for four
digit year and"yy" for two digit year. The month is "m" for single digit
month, "mm" - two digit - 03, "mmm" for MAR, and "mmmm" for full spelling.
"d m yy" would look like 1 1 06.
"d/m/yy" would look like 1/1/06.
"mm/dd/yyyy" would look like 01/01/2006.

h for hour
n for minutes
s for seconds

"d mmmm yyyy hh:mm:ss" would look like 1 January 2006 06:32:05.