Recall records with Date and Time

[drc]

Have a survey db that utilizes time zones and timestamps with a delay to pull
records up based on the last entry in the record. Now I need to add a
CallBack Date and CallBack Time and that needs to supercede the delay on the
timestamps.
Any ideas?

 

[John W. Vinson]

Have a survey db that utilizes time zones and timestamps with a delay to pull
records up based on the last entry in the record. Now I need to add a
CallBack Date and CallBack Time and that needs to supercede the delay on the
timestamps.
Any ideas?

What's a "delay"? What's the context? How do you "utilize"?

More info please!

 

[drc]

Here is the delay code:
Dim delayhold

delayhold = Globs.gintRecallAttemptsAfter * 0.2499

sqlstring(8) = "(((InUse) Is Null) AND (((Now())-([Attempt1TS])) Is
Null Or ((Now())-([Attempt1TS]))>=" & delayhold & " AND [Attempt2TS] Is Null)
Or (((InUse) Is Null) AND ((Now())-([Attempt2TS])) Is Null and
((Now())-([Attempt1TS]))>=" & delayhold & " Or ((Now())-([Attempt2TS]))>=" &
delayhold & " AND [Attempt3TS] is null) OR (((InUse) Is Null) AND
((Now())-([Attempt3TS])) Is Null AND ((Now())-([Attempt1TS]))>=" & delayhold
& " AND ((Now())-([Attempt2TS]))>=" & delayhold & " Or
((Now())-([Attempt3TS]))>=" & delayhold & ")))"

I have added 4 (x represents 1-4 on the attempts) sets of
AttemptXCallBackDate and AttemptXCallBackTime and can't get the record with a
CallBack Date and Time field to override the above code.

 

[John W. Vinson]

Here is the delay code:
Dim delayhold

delayhold = Globs.gintRecallAttemptsAfter * 0.2499

sqlstring(8) = "(((InUse) Is Null) AND (((Now())-([Attempt1TS])) Is
Null Or ((Now())-([Attempt1TS]))>=" & delayhold & " AND [Attempt2TS] Is Null)
Or (((InUse) Is Null) AND ((Now())-([Attempt2TS])) Is Null and
((Now())-([Attempt1TS]))>=" & delayhold & " Or ((Now())-([Attempt2TS]))>=" &
delayhold & " AND [Attempt3TS] is null) OR (((InUse) Is Null) AND
((Now())-([Attempt3TS])) Is Null AND ((Now())-([Attempt1TS]))>=" & delayhold
& " AND ((Now())-([Attempt2TS]))>=" & delayhold & " Or
((Now())-([Attempt3TS]))>=" & delayhold & ")))"

I have added 4 (x represents 1-4 on the attempts) sets of
AttemptXCallBackDate and AttemptXCallBackTime and can't get the record with a
CallBack Date and Time field to override the above code.

So your delayhold is in units of 0.2499 days? You're aware that a date/time
field is store in units of days, right? Could you perhaps use the DateDiff()
function rather than Now()-[Attempt2TS]?

I'm just not sure I understand the logic here.

 

[drc]

The reason we are using the .2499 days is we have a configuration table which
allows them to set recall of the survey (record) based on 6 hours, 12 hours,
18 hours or 24 hours and now we want to supercede it with the callbackdate
and callbacktime

Here is the delay code:
Dim delayhold

delayhold = Globs.gintRecallAttemptsAfter * 0.2499

sqlstring(8) = "(((InUse) Is Null) AND (((Now())-([Attempt1TS])) Is
Null Or ((Now())-([Attempt1TS]))>=" & delayhold & " AND [Attempt2TS] Is Null)
Or (((InUse) Is Null) AND ((Now())-([Attempt2TS])) Is Null and
((Now())-([Attempt1TS]))>=" & delayhold & " Or ((Now())-([Attempt2TS]))>=" &
delayhold & " AND [Attempt3TS] is null) OR (((InUse) Is Null) AND
((Now())-([Attempt3TS])) Is Null AND ((Now())-([Attempt1TS]))>=" & delayhold
& " AND ((Now())-([Attempt2TS]))>=" & delayhold & " Or
((Now())-([Attempt3TS]))>=" & delayhold & ")))"

I have added 4 (x represents 1-4 on the attempts) sets of
AttemptXCallBackDate and AttemptXCallBackTime and can't get the record with a
CallBack Date and Time field to override the above code.

So your delayhold is in units of 0.2499 days? You're aware that a date/time
field is store in units of days, right? Could you perhaps use the DateDiff()
function rather than Now()-[Attempt2TS]?

I'm just not sure I understand the logic here.

 

[John W. Vinson]

I'm sorry, drc, but I've read this several times and I really have no idea
what you're talking about. You're assuming that strangers like me will
understand your business process, what the "configuration table" is, and what
"supercede" is all about.

The reason we are using the .2499 days is we have a configuration table which
allows them to set recall of the survey (record) based on 6 hours, 12 hours,
18 hours or 24 hours and now we want to supercede it with the callbackdate
and callbacktime

Here is the delay code:
Dim delayhold

delayhold = Globs.gintRecallAttemptsAfter * 0.2499

sqlstring(8) = "(((InUse) Is Null) AND (((Now())-([Attempt1TS])) Is
Null Or ((Now())-([Attempt1TS]))>=" & delayhold & " AND [Attempt2TS] Is Null)
Or (((InUse) Is Null) AND ((Now())-([Attempt2TS])) Is Null and
((Now())-([Attempt1TS]))>=" & delayhold & " Or ((Now())-([Attempt2TS]))>=" &
delayhold & " AND [Attempt3TS] is null) OR (((InUse) Is Null) AND
((Now())-([Attempt3TS])) Is Null AND ((Now())-([Attempt1TS]))>=" & delayhold
& " AND ((Now())-([Attempt2TS]))>=" & delayhold & " Or
((Now())-([Attempt3TS]))>=" & delayhold & ")))"

I have added 4 (x represents 1-4 on the attempts) sets of
AttemptXCallBackDate and AttemptXCallBackTime and can't get the record with a
CallBack Date and Time field to override the above code.

So your delayhold is in units of 0.2499 days? You're aware that a date/time
field is store in units of days, right? Could you perhaps use the DateDiff()
function rather than Now()-[Attempt2TS]?

I'm just not sure I understand the logic here.