DateTimeParse Question

[gayathri27]

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.

[Felipe_Ribeir0]

Hi @gayathri27 

One way of doing this:

[gayathri27]

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

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

[grazitti_sapna]

Hi gayathri27

I have attached the workflow for your reference.

Thanks!

[gayathri27]

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?