[SalesForce] Setting a default TIME value only, on a Date/Time field

We have a Date/Time field on a custom object which lets us choose the date (perfect!), but defaults the time as 12:00:00. We want it to default to 09:00:00.

I tried to go and change the default value (when editing the field) to be set as 09:00:00 every time, but it required me to pre-set a date – which should be chosen manually by the user.

How do I default the time only on this date/time field?

Best Answer

I asked on the admin community and got a formula that works! Need to create a workflow rule that runs only when a record is created, the field update should be as below:

Formula

Related Topic