DateTimeParse Question
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
