Workflow to set date and time in a specified field

  • 30 November 2017
  • 2 replies
  • 14 views

Badge

I have a date/time field I want to populate once "yes" is answered to another field.  I have the below workflow:

RUN IF = QA Review = Yes

CALCULATE DATE = both "Use date when action is executed" and "Include time" are checked.  Store Date in QADate variable.

SET FIELD VALUE = Set "QA Review Date Stamp" equals Workflow Data QADate.

It works, except the time always say 12:00 AM!  Why would this be?  I have also tried calculated value to formatDate(QA Review, "mm dd yyyy hh:ss tt), but the time never changes from 12:00 AM.

Please advise.

Thank you!


2 replies

Badge +9

Can you insert build string and use insert reference to add current date and current time from common section to a variable and use that variable to set field value?

Userlevel 5
Badge +14

it should work.

can you proof-check tat list filed really can show time part?

can you post configuration of calculate date action?

can you write value of QADate variable to history log after calculate date action?

Reply