Field Service

Get Involved. Join the Conversation.

Topic

    Vi Giout
    Set modified field with current datetimeAnswered
    Topic posted February 4, 2019 by Vi GioutBronze Medal: 1,250+ Points, tagged Configuration 
    52 Views, 7 Comments
    Title:
    Set modified field with current datetime
    Summary:
    Set modified field with current datetime
    Content:

    We are changing with internal messages some values of our Activities based on different events (activity started, suspended, passed the ETA, not done etc) and we would like to update each time the field modified to contain the date and time of the change. 

    We havent found the way to do exactly that. We have thought of using predefined fields such as start time but this only shows time and not the date.

    Best Comment

    Vi Giout

    Used {message_time_of_content_generation} for those ones

    Comment

     

    • Zsolt Tolgyesi

      Hi Vassiliki,

      Wild idea, but did you tried with the
      now("yyyy-MM-dd HH:mm:ss")
      formula? (This is coming from Admin guide, within Language Expressions section related to field visibility.)

      Regards,
      Zsolt

      • Vi Giout

        Thank you for the suggestion. Unfortunately, the expression does not get calculated and I haven't found an option to treat it as an expression instead of text.

        I am using the now("yyyy-MM-dd HH:mm:ss") in the message body of a set property message scenario and it get inserted as a text. So on the UI I am getting: 

        Modified now("yyyy-MM-dd HH:mm:ss")