Bring in date and time into one field

[Ruegen]

I have two fields - one stamps the date and the other the time (there is also a checkbox which says that these should only be included if true)



One is a call back date and the other is a call back time

the call back date needs to be equal to or less than current date

however

the call back time needs to be before the current time by 5 minutes and still appear if the date is below current date (some dates might have the time after the current "Time()" )

how would I write this?

I tried concatenating the fields into another field but it gives me dates above current date - not working for me

p.s. Robin Williams died today so I'm sad.

[Ruegen]

whoops - nevermind

I think this will solve

IIf([callbackdate]=Date(),<=DateAdd("n",10,Time()),[callbacktime])

let me know if I'm correct/wrong.

[June7]

The use of <= makes no sense to me.

[Ruegen]

The use of <= makes no sense to me.

less than or equal to current time minus 10 min?

[June7]

Where are you using this expression? As criteria in a query? Okay, that makes more sense.

[Ruegen]

query

I use it to make a form that lists records within the criteria. If one falls under then the form pops up and they can see it is someone they have to call 2-5 min before the time as a reminder.

I use this on their switchboard timer (I make it pass 10 seconds every time the timer = 1000 using a public variable)

Basically they get popup reminders of who to call

[Ruegen]

I'm still working on this - I couldn't get all results to show

so I'm trying this

BoolRemove: IIf(([callbackdate]=Date() And [callbacktime]<=Time()) Or (IsNull([callbackdate]) And Not IsNull([callbacktime])),True,False)

If I can get everything that is either null or before the date to be true then I can only show those (which is what I want)

however sometimes folks fill both date and time fields and they are before current date.

[Ruegen]

working formula

belowtime: IIf(IIf([CallBackDate]<Date() Or IsNull([CallBackDate]),True,False) Or IIf([CallBackDate]=Date() And [CallBackTime]<Time(),True,False)=True,True,False)