Automatic year in Date Problem :(
-
I want to enter Month and Date only in date field. No year. But Access 2000 puts year in the field by itself. :( I read an article on MS site that this is a default functionality in Access2000. There should be an option to check this functionality off. I am using VC++. I get records from Access and put them in a grid. Since the Datagrid 6.0 control is bound to the db, it displays the year too. I am sorting data on date, so I cant change the field to "Text" type. I dont want the year to be there. How do I save month and date only in mdb file? HELLLLPPP!!! Ammar
-
I want to enter Month and Date only in date field. No year. But Access 2000 puts year in the field by itself. :( I read an article on MS site that this is a default functionality in Access2000. There should be an option to check this functionality off. I am using VC++. I get records from Access and put them in a grid. Since the Datagrid 6.0 control is bound to the db, it displays the year too. I am sorting data on date, so I cant change the field to "Text" type. I dont want the year to be there. How do I save month and date only in mdb file? HELLLLPPP!!! Ammar
you must remember that access (and most db's i know of) store date / times in a kind of julian format (ie, the number of days since 1st jan 1900, for example, and the number of milliseconds since midnight) now saying "i dont want to store the year part of a date" is like saying you don't want to buy bananas with their skins on, ie, not in this world am not sure about data-bound grids (never use them cos you get all the hassles u are dealing with) but if you were to use unbound mode for the grid you could split the dates yourself and display only the day and month part of the date hmmm ... isnt there a PreDisplayData() type function you could trap into and do the same in bound mode? --- "every year we invent better idiot proof systems and every year they invent better idiots"
-
I want to enter Month and Date only in date field. No year. But Access 2000 puts year in the field by itself. :( I read an article on MS site that this is a default functionality in Access2000. There should be an option to check this functionality off. I am using VC++. I get records from Access and put them in a grid. Since the Datagrid 6.0 control is bound to the db, it displays the year too. I am sorting data on date, so I cant change the field to "Text" type. I dont want the year to be there. How do I save month and date only in mdb file? HELLLLPPP!!! Ammar
Make your own grid... Do not sound nice, but you can't get rid of the year in a date/time field in access... - Anders