By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Adapting non-standart date formats to the date field

P: n/a
Hey again newsgroup,

I am still working on an archive database and got another problem: I
have to classify the folders by a date or a date range which has the
format mm/yyyy
I got the feeling, that I should try at every price to also use the
date/time field as it offers many benefits like easy searching or
automatic controlling of values.
As mm/yyyy is none of the regular types, I got several possibilities:

- Creating an own date system (integer or string, converted into
yyyymm format for easy search) with the disadvantage of not having a
date field
- Working around by transforming the mm/yyyy to eg. 01/mm/yyyy (which
would be fine for them I suppose)
- Finding a possibility for native mm/yyyy support.

Neither google nor the F1 key gave very much information on that
specific subject, so I#m askking

thanks in advance
Thorben Grosser

Jul 24 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Internally, Access represents the date/time data type as a special type of
real number, where the integer part represents the date, and the fraction
part the time (as a part of a day.) Therefore it is not possible to record a
date that consists of year and month only (no day.)

Best choice would probably be to store the first of the month, and format it
how you wish.

Another viable choice would be to use 2 fields of type Number (size
Integer): one for the year, one for the month.

Careful though: don't use names like Date, Time, Year as field names.
They're all reserved words:
http://allenbrowne.com/AppIssueBadWord.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Thorben Grosser" <th*************@gmail.comwrote in message
news:11**********************@o61g2000hsh.googlegr oups.com...
Hey again newsgroup,

I am still working on an archive database and got another problem: I
have to classify the folders by a date or a date range which has the
format mm/yyyy
I got the feeling, that I should try at every price to also use the
date/time field as it offers many benefits like easy searching or
automatic controlling of values.
As mm/yyyy is none of the regular types, I got several possibilities:

- Creating an own date system (integer or string, converted into
yyyymm format for easy search) with the disadvantage of not having a
date field
- Working around by transforming the mm/yyyy to eg. 01/mm/yyyy (which
would be fine for them I suppose)
- Finding a possibility for native mm/yyyy support.

Neither google nor the F1 key gave very much information on that
specific subject, so I#m askking

thanks in advance
Thorben Grosser
Jul 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.