Welcome, Guest. Register Now!
   
Mark Forums Read Mark Forums Read Mark Forums Read


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-27-2008, 05:16 AM
Junior Member
 
Join Date: Oct 2007
Posts: 5
iTrader: (0)
Raynewp is on a distinguished road
Default Help needed in entering just the year or jus month and year in a date field

I have a database in which I have fields for date of birth and death date. The problem is that for some members only the year, or the month and year is known for either or both of these fields. The fields are Date fields and are formatted as dd-mmm-yyyy with an input mask of: 00\->L Is there a way I can enter just the year, or the year and the month. Every time I try, I get an error message that forces me to enter the complete information, e.g. 01-Jan-1979. If I leave the date or the month blank, I get the error message. Is there a workaround for this situation?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 01-29-2008, 06:22 AM
Member
 
Join Date: Oct 2007
Posts: 41
iTrader: (0)
TonyES is on a distinguished road
Default

Are you using a form to enter these dates?? If so, remove input masks from both the form and the table definition for that field. In my limited testing, I was able to enter dates in multiple different formats into a Date/Time field formatted as dd-mmm-yyyy with no input masks and have them display in the proper way. When I entered only a mm/yyyy combination it assumed the first of that month.....
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 01-30-2008, 06:36 AM
Junior Member
 
Join Date: Oct 2007
Posts: 5
iTrader: (0)
Raynewp is on a distinguished road
Default

Great, you saved lot of time for me.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -6. The time now is 03:14 AM.