Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

EN6924
8 - Asteroid

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

 

EN6924_1-1641893334898.png

 

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

 

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

 

EN6924_0-1641893285890.png

 

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

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @EN6924 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1641893815770.png

 

Hope this helps : )

 

EN6924
8 - Asteroid

Great... It worked perfectly 😊

 

EN6924_0-1641894216742.png

 

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @EN6924 

 

Here is the optimized version of the workflow

 

Workflow:

atcodedog05_0-1641894684192.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @EN6924 

If my response helps please don't forget to mark it as solution. 🙂

Cheers and have a nice day!

EN6924
8 - Asteroid

By using Table tool - I can able to create border on both side of the column

 

EN6924_1-1641899781066.png

 

EN6924_0-1641899636622.png

 

Can I create a single line border on the entire table? and for header a bold border? Just like we can do in excel -

 

EN6924_2-1641900096185.png

 

 

 

 

EN6924
8 - Asteroid

I tried changing the dates and found some errors marked in yellow.

 

EN6924_0-1641901808516.png

 

Please help me writing the formula properly.

 

atcodedog05
22 - Nova
22 - Nova

Hi @EN6924 

 

Here is how you can do it.

 

Workflow:

atcodedog05_0-1641907195928.png

 

Hope this helps : )

 

Labels