Date Expiration

HCL Domino Domino Forum
1

I have a form,In this form i have fillup the entry of asset.In this form, a field named Expire date which contain expiration date of perticular asset.I fill this date entry by creating a field name Expire date, the type of field is date/time and style is calender/time control.Now i want to generate an automatic mail before one week the date i enter in the expire field with subject-"Remainder, The expire date of (asset no.)is DD/MM/YYYY "

If someone have any idea, kindly suggest me.

How can i automate it through lotusscript or formula.

2

Subject: Automatic reminder

Create a daily scheduled agent. In @Formula, here is the basic idea:

SELECT (Form=“Myform”) & (@Date(@Today)>@Adjust(ExpirationDate;0;0;8;0;0;0)) ;

@MailSend (recipientnames;“”;“”;“Reminder, The expire date of (” + @Text(AssetNum) + ") is " + @Text (ExpirationDate); “”; “”) ;

For the syntax details, dig the documentation…

Thierry Cayla

http://dominoeffects.serveblog.net

3

Subject: recipients type…

Thierry; in which format i typed the name of recipients-hierarchiacal name or email type because if i type

@MailSend (hariom s/ou/xyz;“”;“”;“Reminder, The expire date of (” + @Text(AssetNo.) + ") is " + @Text (AMCExpire); “”; “”).

then it gives error- an error or semicolon expected but none was encountered.So what i do.

4

Subject: Recipient name

Doesn’t matter, but if you hardcode it, better put double-quotes around, or it will obviously complain for a bad syntax. Right version is:

@MailSend (“hariom s/ou/xyz”;“”;“”;“Reminder, The expire date of (” + @Text(AssetNo.) + ") is " + @Text (AMCExpire); “”; “”)

Anyway, check the @MailSend syntax in the help, it’s quick and free.

Thierry Cayla

http://dominoeffects.serveblog.net

5

Subject: Hi Thierry

actually i have created an agent which runs daily(schedule) but nothing be hapeened.Could this done by any “IF” condition in formula language?Could u clear this >>(@Date(@Today)>@Adjust(AMCExpire;0;0;8;0;0;0));?

Any other condition is avalibale…plz help me.