2 Replies Latest reply on Apr 29, 2013 3:15 PM by Sambit K

    Find closest date before current date

    Sambit K

      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.