Date selection

HCL Domino Domino Forum
1

I have a notes database with one form (& many views) there is a salesman’s field on the form which has a call back date. i need to run an action each day to send an email to the salesman as a reminder if the call back date is = to todays date. if i amend the action manually to select documents where call back date = @Today & then use the select @mailsend option it works. if i schedule that action, it will work for today but next day it is still trying to select ‘yesterdays date’ i need to automate this and have it run as a scheduled action each morning. Any ideas or suggestions would be appreciated Regards

Peter E

2

Subject: Agent code?

If this agent is created with formula, then @Today should automatically be today’s date, and not yesterday’s date.

Perhaps you can post your code? It should be something similar like:

@If(@Date(callbackdate_field) = @Today;

@MailSend(…);“”);

In the agent properties set the target to ‘all documents’

3

Subject: date selection

hi i have added your code and if i run the agent from the action menu it works fine. If i schedule it to run it doesnt appear to work !!

that action i have created is :-

SELECT @If(@Date(callback) = @Today;

@MailSend(WhoTo ; “” ; “” ; “A call back is required by you today " ; “”; “Company”: " - " : “ProsProd” :” Please click the link to access the CVM record “; [IncludeDoclink]) ;”")

any further suggestions would be appreciated

Regards