GH

Hi,

How can I handle a date format of this type in MashZone : "2011/10/10, 18:57" ?

This is an unrecognised date format, I can't find how to convert it to a recognised date format using regular datafeed tools and as I long as I know we can't use regex.

Do you have any idea ?

Note : I'd rather not have to modify the date format in the xls feed itself.

 

Thank's a lot,

Gaël.

by Markus von den Driesch
Posted on Thu, 10/10/2013 - 16:05

Hi,

import this as a "Text" datatype column. Then apply a "Convert column" operator with the new datatype "Date". On the right-hand side of datatyp selection there is option for advanced settings.

Enter the following pattern for your date format: yyyy/MM/dd, hh:mm

 

Best regards.

0
by Gaël Hérent Author
Posted on Thu, 10/10/2013 - 16:53

Great !

Thank's a lot Markus.

 

Regards,

Gaël.

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • Profile picture for user frankweise
  • Profile picture for user Henrik Buckler
  • Profile picture for user UffeK
  • SS
  • MZ
  • PacMan

Leaderboard

|
Nobody has collected any points yet this week. This is your chance to become one of the top 5 on this week's leaderboard.
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock