Hello,
I have a timestamp field which looks like this 2024-07-10 13:36:55
I need to remove the colon ":" from this field and keep everything else as it is.
The output should be like 2024-07-10 133655.
I tried this in the formula tool but could not do it.
Can someone please help me out with this.
Thanks so much.
Solved! Go to Solution.
This can be achieved with the help for Formula tool.
Replace([Timestamp], ":", "")
Note: The timestamp column might be in datatype date or datetime.
When using the formula tool, save the output in the different column name with datatype as VWstring
Many thanks
Shanker V
@Gandalf_NotGrey
Can you tell us which function you are using?
Thanks @ShankerV @Qiu @flying008 - This is working now. Thanks so much for your help.