I have a data where there is a column named "Start Date" of String data type I need to create 2 separate columns based on that record. * 11-01-2022 – This should be showing as “Last Backup happened on 11th January 2022” in a separate column. I did it, kindly give me your opinion that the process is correct or not. * How can I convert the hh:mm:ss to AM/PM? For example - 02:00 will show – Backup initiated on 2 AM 00:11:05 will show – Backup initiated on 12:11 AM 09:00:14 will show – Backup initiated on 9 PM 00:00:00 will show - Backup initiated on 12 AM This should be showing in another column named - "Backup Schedule Time" Please help 1.yxmd

How can I convert the hh:mm:ss to AM/PM?

I have a data where there is a column named "Start Date" of String data type

I need to create 2 separate columns based on that record.

11-01-2022 – This should be showing as “Last Backup happened on 11th January 2022” in a separate column.

I did it, kindly give me your opinion that the process is correct or not.

02:00 will show – Backup initiated on 2 AM

00:11:05 will show – Backup initiated on 12:11 AM

09:00:14 will show – Backup initiated on 9 PM

00:00:00 will show - Backup initiated on 12 AM

This should be showing in another column named - "Backup Schedule Time"

Please help

Here is how you can do it.

Workflow:

Hope this helps : )

Here is the optimized version of the workflow

Workflow:

Hope this helps : )

Here is how you can do it.

Workflow:

Hope this helps : )

Here is how you can do it.

Workflow:

Hope this helps : )

Great... It worked perfectly 😊