• bhanu p
  • 0 Points
  • Member since 2016
  • b

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 3
Ideally I'd store the hour in a formula field (10:23 = 10 and 3:49 = 13, etc.)
I Have a field like opportunity_hour, in this field i need to capture record created time into another field?User-added image
Ideally I'd store the hour in a formula field (10:09 = 10 and 3:36 = 15, etc.)
Thoughts on how best to do this?

I'm trying to validate step 5 for the Security Specialist superbadge "Set up reporting error" and I'm geeting the following error :

Challenge Not yet complete... here's what's wrong:
The Field Sales User profile does not appear to have the correct permission for create and customize reports.

I don't understand what's wrong cause I've check all reports permissions on the Field Sales User profile.

Could you please advice ?

Hi All,

I have logged in as System Admin and switch to Standard User form Manager User. When I try to logout from the Standard User interface, instead of landing to  System admin setup page, I am logout from the salesforce.com.

I am a bit of a beginner at formulas, so hopefully one of you will think this is easy, and be able to help. :-)


Customer requirement:


Create a formula field that displays the Week Number (as Week 1, Week 2, etc), based on the Date entered on a particular record (same object).


Ex: 01/01/09 - 01/04/09 would return a value of "Week 1"  

01/05/09 - 01/11/09 = Week 2

01/12/09 - 01/18/09 = Week 3


and so on.....


Is using the CASE function the way to go, and if so, what's the shortest way to create this formula?


Thank you in advance!



  • April 20, 2009
  • Like
  • 0