Replace values in a time column: Replace errors with "Current Time"

[Anonymous]

Hi, I am trying to replace error values in a Time column to the "Current Time".  The syntax I suppose should do this, is DateTime.Time(DateTime.LocalNow()).   However, this option doesn't seem to be viable.  

Any advice please?

Kind regards,

Malan

[Mariusz · Accepted solution]

Hi @Anonymous 

You can not do it with the UI as it will not accept functions, however, you can do it by:

Replacing Errors with 00:00:00 like below.

And later replacing the #time( 0, 0, 0 ) in your Replaced Error Step with your expression, like below

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.