Workflow - Date and Time

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.

Workflow

Accepted answers

PanPP

Hi @iamRandy

This workflow outputs the following formatted output:

Workflow - Date and time.png

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.

Sample WF - Create date.yxmd

All comments

PanPP

Hi @iamRandy

I have uploaded a sample workflow that accomplishes this.

Sample WF - Create date.yxmd

Felipe_Ribeir0

Hi @iamRandy

One way of doing this

Workflow - Date and Time.yxmd

iamRandy

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

PanPP

Hi @iamRandy

This workflow outputs the following formatted output:

Workflow - Date and time.png

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.

Sample WF - Create date.yxmd

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235