Tickler Function 1

[johnnym]

Hello, I am looking for any help I can get on creating a 'tickler' function. I want this function to query records in a training database and retreive the records where training took place over 23 months ago. I would like this to run automatically and pop up a message and/or print report when training is 23 months old.
Any help would be greatly appreciated.

Thank you

 

[Eradic8or]

Use the datediff control to determine if the difference between the recorded date and now() ir greater than 23 months. I am sure that this control returns days so you would have to calculate on this basis.

Eradic8or

 

[MichaelRed]

johnny,

DateDiff is the correct FUNCTION, I am not aware of a CONTROL named 'datediff'



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[Eradic8or]

Sorry. My mistake
Least the answer was right (sort of)

Eradic8or

 

[johnnym]

Thank you for the information, it has been most helpful.

 

[Eradic8or]

Glad to be of help.

Eradic8or