0

I have a number formula field. It should display current time in hh.mm format. I am writing Date/Time functions but it doesn't seem to work. Please provide solution for this.

  • 1
    Why return a Number instead of a Date/Time? – Dan Jones Dec 20 '16 at 11:58
  • 1
    If you want help with a formula field it is best to include what you have so far so that it is possible to say what you are doing wrong. – Dave Humm Dec 20 '16 at 12:00
  • There is a similar post for the solution I think you are seeking.Can you check this and see if it helps you? salesforce.stackexchange.com/questions/42626/… – Abhijeet Dec 20 '16 at 12:03
0

Here is the final formula:

DATETIMEVALUE(TEXT(YEAR(Start_Date__c))+"-" +TEXT(MONTH(Start_Date__c))+"-" +TEXT(DAY(Start_Date__c))+" "+TEXT(VALUE(LEFT(Start_Time__c, 2))+ 7)+  MID(Start_Time__c,3,3)+":00")
| improve this answer | |
0

Use the Text formula field and below definition -

MID(TEXT(NOW()),12,5)
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.