Re: Temporarily change a date field

Make that DateValue(DateAdd("h", -6, [EventStart])

--
KARL DEWEY
Build a little - Test a little


"Douglas J. Steele" wrote:

Try:

DateValue(DateAdd("n", -6, [EventStart])

Incidentally, your date is NOT stored with any format. Date/Time fields are
eight byte floating point numbers, where the integer portion represents the
date as the number of days relative to 30 Dec, 1899, and the decimal portion
represents the time as a fraction of a day.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"James Frater" <JamesFrater@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:93D2FF8A-E5F2-4F1F-ADF6-64065CEC21AD@xxxxxxxxxxxxxxxx
Afternoon All,

I have a time/date field [EventStart] with the format (dd/mm/yyyy
hh:mm:ss)
that feeds into a Flexgrid, but to make it match up with the way schedule
staff and work load, I need to temporarily amend the date so it slots into
the right part of the grid.

My Flexgrid runs for a 24hour period from 06:00:00 to 05:59:00. So where a
piece of work is scheduled to start at 27/06/2008 02:00:00, I need to
amend
the date so it sits on the flexgrid that starts on the 26/06/2008.

I've tried using DateDiff and also .edit followed by a .update, but
neither
options seem to work.

Any ideas folks?

JAMES




.