Forum Discussion
Replace values in a time column: Replace errors with "Current Time"
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
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.
1 Reply
- Mariusz
Community Champion
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.