Use date when action is executed is not returning the current time (hours minutes seconds)

  • 12 August 2015
  • 6 replies
  • 3 views

Badge +4

When I select the check "Use date when action is executed" is not returning the current time, only the current date.

By default UTC midnight is set as returned time, but I also need to get the current hour, minutes and seconds.

How I can do to get the current time too?

thank you!


6 replies

Userlevel 5
Badge +9

You can create a single line of text variable in your workflow and set it with a "Set variable" action like the following :

108272_pastedImage_0.png

The "Current Date" and "Current Time" are in the "Common" tab of the "Insert reference" screen.

Then you can use this variable to set a datetime column like this :

108273_pastedImage_1.png

Hope this helps

Badge +4

Thank you Caroline, that Works! happy.png

Userlevel 5
Badge +12

Awesome work around. happy.png

Userlevel 5
Badge +9

wink.png

Badge

I think it is better to use the calculate date action with the "include time" checkbox checked and then use that variable to update your date/time field. This allows you can do calculations based on that field. I haven't tested the original solution yet but I am worried that combining the date and time together like that wouldn't allow you to do calculations based on it.

Badge +12

@alexhood87 ....Seems you're 4 years late to respond.... :D

 

@ignasitt ....Are you sure that you did check both check boxes? 

  • Use date when action is executed
  • Include time

 

Reply