Unrecognised date format

Last activity on October 1, 2023 - 11:21 27.6k Views 2 Replies MashZone

Gaël Hérent on October 9, 2013

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.

Bookmark

Notify Moderator

2 Replies

Markus von den Driesch on October 10, 2013

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.

Like

Sign in
or register to reply.

Notify Moderator
GH

Gaël Hérent Author on October 10, 2013

Great !

Thank's a lot Markus.

Regards,

Gaël.

Like

Sign in
or register to reply.

Notify Moderator

There are currently no upcoming events.