This discussion is archived
2 Replies Latest reply: Apr 29, 2013 8:15 AM by 965000 RSS

Find closest date before current date

965000 Newbie
Currently Being Moderated
Hi,

How to get the closest date record before the current date record using workflows(preferably) ?

Detailed :-

For e.g. A record is created with status as "Open". On click of a button a program should be invoked(workflow or script) to fetch the most recent records with status as "Open".

That means if a new record is created today and already there are 3 records with same status as "Open" with two created yesterday and one created 2 days before.Then our program should fetch only those two records created yesterday and not the one created two days before.

Thanks
Sambit

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points