Anybody use Base?

Alex · 01-24-2010, 05:43 PM

Anybody here familiar with Base, the database component of Open Office?

I had a small task that I thought I'd try doing in a database rather than my standard practice of just bruting it in Excel. So I tried setting it up in Base since I have that and have never played with it.

For some reason, a date field I have automatically changes to 1/1/1800 any date I enter that is prior to that. So 6/5/1756 becomes 1/1/1800.

But only when doing data entry through a form. When I do it directly in a table it is saved correctly (though still appears as 1/1/1800 in the form view).

Anybody use and have thoughts? I can find zero help on this online so I'm sure it is something really stupid I'm doing.

01-24-2010, 05:43 PM	#1
Alex . Join Date: Feb 2005 Posts: 13,354	Anybody use Base? Anybody here familiar with Base, the database component of Open Office? I had a small task that I thought I'd try doing in a database rather than my standard practice of just bruting it in Excel. So I tried setting it up in Base since I have that and have never played with it. For some reason, a date field I have automatically changes to 1/1/1800 any date I enter that is prior to that. So 6/5/1756 becomes 1/1/1800. But only when doing data entry through a form. When I do it directly in a table it is saved correctly (though still appears as 1/1/1800 in the form view). Anybody use and have thoughts? I can find zero help on this online so I'm sure it is something really stupid I'm doing.
	Submit to Quotes