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