Setting fields to specific Datetime in Workflow Formula

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • luizthomasini
    Junior Member
    • Oct 2020
    • 12

    Setting fields to specific Datetime in Workflow Formula

    Hi, maybe you could help me with this.

    I'm trying to set a Datetime field through Formula in workflow when a record gets updated. I'm having issues with setting it to a specific time.


    For exemple:

    I want dateStart to be set the next day at 09:00.

    I can change the date with:

    dateStart = datetime\addDays(datetime\now(), '1')


    Am I able to set hours and minutes to specific value?
  • Maximus
    Senior Member
    • Nov 2018
    • 2731

    #2
    Hi there,
    please investigate these examples:
    Code:
    dateTime = datetime\addDays(dateTime, 1);
    dateTime = datetime\addHours(dateTime, 3);
    dateTime = datetime\addMinutes(dateTime, 15);

    Comment


    • luizthomasini
      luizthomasini commented
      Editing a comment
      Thanks! Made it work using some other built-in functions.
Working...