Workflow - Date and Time

[iamRandy]

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.

[PanPP]

Hi @iamRandy 

I have uploaded a sample workflow that accomplishes this.

[Felipe_Ribeir0]

Hi @iamRandy 

One way of doing this

[iamRandy]

The Create_Time_1 has a date .. i need time only. there no function. thanks :)

[PanPP]

Does the workflow I uploaded provide the desired output?

[iamRandy]

@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.

[PanPP · Accepted solution]

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.