AnsweredAssumed Answered

Find expired date Record values in a Found Set & send that to recipients in one mail

Question asked by Suresh on Oct 22, 2016
Latest reply on Oct 22, 2016 by Suresh

Good Evening All.


I have a table with two fields

1. pk_Task

2. Target Date


If Task's target date is expires today means have to find all records & find out the expire target and send one mail to some recipients.


So in that one mail i required to come as,

     Target Expires Today
     Task : Task 2119 
     Target : 22-Oct-16
     Task : Task 3168
     Target : 22-Oct-16
     Task : Task 3389 
     Target : 22-Oct-16


So how to make a script for this!


Help much appreciated!


- Suresh