I have a workflow field that i need to separate the Date and Time on its own individual field, and i'm unbale to determine what function to use to accomplish this. For example,
Creation_Date: 2022-10-16 07:48:01.000
I need to create a Create_Date column with 2022-10-16 values only and Create_Time with 07:48:01.000 (without the .000)
Please advise.
Thanks.
Solved! Go to Solution.
The Create_Time_1 has a date .. i need time only. there no function. thanks :)
Does the workflow I uploaded provide the desired output?
@PanPP we are customizing the date and time field so we can filter the time in tableau application for time only that's why i need to parse out just the time from date and time. Desired Output is in my original post.
Hi @iamRandy
This workflow outputs the following formatted output:
Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.