2 Replies Latest reply: Apr 29, 2013 10:15 AM by 965000 RSS

    Find closest date before current date

    965000
      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