Prefill Date/Time field with specific hour and minute

Question

I'm using a publisher action to help add time entries for users. The time entry record captures a start date time and end date time.

I'm making an "8 hour entry" publisher action, where my user can specify type of activity and give the day, and I'll calculate the rest.

How do I build a formula to populate Start Date Time with today's date at 6:00AM, and then End Date with today's date at 2:00PM?

Thanks!

Mayank Srivastava · Accepted Answer

Micah, your formula would be this:

DATETIMEVALUE( 
  TEXT(YEAR(TODAY())) + "-" +
  TEXT(MONTH(TODAY()))+ "-" + 
  TEXT(DAY(TODAY()))  +
  " 06:00:00"
)

Now remember that the above DATETIMEVALUE is always calculated in GMT so you will have to make adjustmetns to the formula to make it show the correct value. Good luck!

Navneet Kumar · Answer

For 6AM today   DATETIMEVALUE(TEXT(YEAR(Today()))+"-"+TEXT(MONTH(Start_Date__cToday()))+"-"+TEXT(DAY(Start_Date__cToday()))+" "+(6:00))﻿

Prefill Date/Time field with specific hour and minute

Data Management

Aprendizagem relacionada

Mais ajuda