In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

DateTimeParse Question

gayathri27
7 - Meteor

Hello ! How do I convert 01/08/9 10:55:13 which is in string format to split the date and time? I tried using DateTimeParse and did not have any luck. After I split the date and time I need to convert or identify what day of the month it is. The string is in DDMMYY HH:mm:ss

Your help is much appreciated.

5 REPLIES 5
Felipe_Ribeir0
16 - Nebula

Hi @gayathri27 

 

One way of doing this:

 

save.png

gayathri27
7 - Meteor

@Felipe_Ribeir0  I tried the formulas that you suggested but i still do not see them split and giving me the day. please see attached screen shot

caltang
17 - Castor
17 - Castor

@gayathri27 you are clicking on the input portion of the formula tool. Click on the output portion - the green arrow facing the right, then your results will appear.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
grazitti_sapna
17 - Castor

Hi gayathri27

 

I have attached the workflow for your reference.

Thanks!

Sapna Gupta
gayathri27
7 - Meteor

Hi Sapna,

Thanks for sharing the workflow. When I tried to use append I am getting this error. After appending to find out which day of the week receives most visitors should I use Summarize - group by Day and Count by No.of visitors, followed by Sort visitors in Descending order?

Labels
Top Solution Authors