"bebelino" <a.*@c.d> wrote in message
news:oo********************************@4ax.com...
I'm working on a calendar-program.
I wonder what the best approach would be for storing the begin- and
end date/time for a particular calendaritem.
Right now I have two fields: Startdate and Enddate. Both date/time.
This is giving me terrible headaches when trying to let the user edit
time-part. Let's say startdate is '01/01/2003 22u15'. When I let the
user edit the 22u15 the datepart is set back to 1899 or something.
It's not the first problem I'm countering wit this one. So I begin to
wonder if it's better to store the startdate for instance in two
fields: startdate and starttime. Both of datatype date/time. Has
anyone got experience on this one? What could be the best approach?
thanks,
--
bebelino
Since you were so helpful with my date problem....
Are you entering the entire date & time in the same field? '01/01/2003
22u15' in startdate? Or entering the date at one point and the time at
another? If you enter the full string in a general date formatted field,
both should remain as entered.
As you've found out, access date/time fields hold both date and time. When
you enter a time formatted field, a date of Dec 30, 1899 (or thereabouts) is
stored with the time just as 00:00 is stored with date formatted fields. It
is best to store them seperately if you want to enter them independently.
Ken