DateAdd

[PeterM]

I have a field in a table that is set to a general number format called
txAlarmDateTime. On a form I have a separate start date (StartDate) and a
separate start time (StartTime). I need to populate the txAlarmDateTime
with a concatination of the StartDate and StartTime.

I want to add 30 minutes to the StartTime and have the following code.

Me.txAlarmDateTime = DateAdd("n", 30, Me.StartTime)

The problem I'm having is that it does add 30 minutes to the StartTime but
the date is 12/31/1899. If the StartTime is 11:00AM and the StartDate is
1/6/2010 then the resulting value is "12/31/1899 11:30AM" but it should be
"1/6/2010 11:30AM".

What am I doing wrong?

 

[John Spencer]

Try
Me.txAlarmDateTime = DateAdd("n", 30, Me.StartDate + Me.StartTime)

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Tom Wickerath]

Hi Peter,

It seems to me like it is doing exactly what you asked it to do....add 30
minutes to the StartTime value. You didn't include StartDate in your
expression. Have you tried this?

Me.txAlarmDateTime = DateAdd("n", 30, Me.StartTime + Nz(Me.StartTime,0))

I threw in the Nz (Convert from null) just in case you have not entered a
StartTime. I haven't taken the time to test this, to see if it actually
works, but offhand me thinks it should work.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[PeterM]

Tom... that worked beautifully and thanks for answering on a Saturday.

Pete

 

[PeterM]

John... that worked beautifully and thanks for answering on a Saturday.

Pete

 

[Tom Wickerath]

Hi Peter,

I'm glad you got it working. I just noticed that I referenced Me.StartTime
twice, but I think you knew what I intended.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________