Insert Current Date and Specified Time

[primagic]

I am trying to insert today's date plus an actual time into a field. I am using an SQL backend.

So basically i have. I am wondering what would appear after Date() or does the entire line need changed?

If Me.CurrentTime >= "09:00" And Me.CurrentTime <= "10:00" Then
Me.NextTaskTime = Date()+ ???
End If

 

[MajP]

times are represented in code #9:00# strings are "9:00"
If the control is unbounded

If Me.CurrentTime >= #09:00# And Me.CurrentTime <= #10:00# Then
Me.NextTaskTime = date + cdate(me.currenttime)
End If

If it is bound to a date field then just add.

 

[primagic]

It is bound to a field with a datetime datatype

So can I use:

If Me.CurrentTime >= #09:00# And Me.CurrentTime <= #10:00# Then
Me.NextTaskTime = date + cdate(#11.00#)
End If

 

[dhookom]

So can I use:

Why not just try it and tell us if it works?
When you tell us the error or problem, we will suggest the value 11.0 is Jan 10, 1900.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

I assume you meant 11:00 not 11.0

If you simply want to add a literal time to a date then
date() + #11:00#
or
date() + 11/24
will work
or the dateadd function
dateAdd("h",11,date())