Date/Time Field in Custom Report Summary Formula? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Nick ValerioteNick Valeriote 

Date/Time Field in Custom Report Summary Formula?

Hi!

I'm looking to create a custom report with a summary formula using 2 date/time fields.  However, when I go to add the fields in my summary formula, they aren't there to be selected. 

1. I'm using the right report type.  Can you not use date/time fields in summary formulas?

2. Also, when I can figure this out, I want to create a report that spits out the number of hours between 2 date/time fields, excluding weekend.  Does anyone have a recommendation on how to create this formula?  I looked at this solution, but not sure it will account for excluding weekends (https://success.salesforce.com/answers?feedtype=RECENT&criteria=BESTANSWERS#!/feedtype=SINGLE_QUESTION_SEARCH_RESULT&id=90630000000D3rUAAS)

Thanks, all!
Nick

Best Answer chosen by Nick Valeriote
Celeste KellerCeleste Keller
Hi Nick,

Unfortunately, date and date/time fields are not available at all in report formulas - only number or currency fields. :(
 

All Answers

Celeste KellerCeleste Keller
Hi Nick,

Unfortunately, date and date/time fields are not available at all in report formulas - only number or currency fields. :(
 
This was selected as the best answer
Celeste KellerCeleste Keller
There is an idea that you can vote for - hopefully the formulas in reports will be updated someday so that they function like other formulas!
https://success.salesforce.com/ideaView?id=08730000000XsUvAAK
 
Nick ValerioteNick Valeriote

Thanks, Celeste...for being the bearer of bad news ;)  I voted.  Cheers.