Edit the seconds on datetime field when updated

Question

My users set a start datetime and end datetime on a record. There's a trigger that checks other records to see if the times overlaps with any of them. The seconds on the datetime field is causing my users to start the next record 5 minutes after they ended their last record, so they can't end a record at 9am and start a new record at 9am if the seconds happened to be greater on the first record, and less on the second record. I'm trying to come up with field update formula to take the time they enter and remove the seconds. Thoughts?

Micah Perry · Accepted Answer

YEAR(), MONTH(), and DAY() can only be used with a date field, not a datetime, but that did help me create this:

DATETIMEVALUE(MID(TEXT(LastModifiedDate), 0, 16) + ":" + "00")

My field isn't last modified, but it works for testing purposes.

Edit the seconds on datetime field when updated

Data Management

Aprendizaje relacionado

Más ayuda