0

I'm trying to put a formula in filter of report and and having difficulty writing it as I'm new to salesforce world. Here is the scenario:

Any record if inserted after 3pm yesterday should be displayed. There is a "Inserted__C" datetime field. I can compare against that. 

Thanks for your help in advance. 

1
  • 1
    In report you can use Last N Days to get in day but for hour I am not sure. Nov 16, 2016 at 17:07

1 Answer 1

1

It is not possible to create that type of formula on a report filter. The closest that you can do is create a formula field on the object itself. Here's a post from the Success community that explains how to accomplish this: https://success.salesforce.com/answers?id=90630000000gnsyAAA

Here is a link to all of the relative date values possible in Salesforce report criteria which sadly only provides days, not hours: https://help.salesforce.com/articleView?id=custom_dates.htm&type=0

3
  • I was able to create custom field to achieve this: if( ISNULL( InsertedDate__C),false , DATETIMEVALUE( TEXT( TODAY() - 1 )+ " 23:00:00" ) < InsertedDate__C ). The only problem with this field is that some customer are located in different timezone. and we want to display their records based on Inserteddate__C ( some uses CST, EST, PST etc). I'm wondering how can I make 23:00:00 dynamic based on the client timezone? inserteddate is storing datetime in CST.
    – HZee
    Nov 16, 2016 at 22:31
  • Here's what I found: help.salesforce.com/HTViewSolution?id=000181642
    – joe.stolz
    Nov 17, 2016 at 21:10
  • I meant to add that I have never tried this myself and do not know if it applies for your situation.
    – joe.stolz
    Nov 17, 2016 at 21:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .