DateTimeParse Question

Question

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.

Core - Visitors to Childrens Museum.xlsx

gayathri27 · Answer

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?

Screenshot (14).png

grazitti_sapna · Answer

Hi gayathri27

I have attached the workflow for your reference.

Thanks!

Date_Day.yxzp

caltang · Answer

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