Skip to main content
  • EN

I am reading an excel file, and seems most datetime fail to read

It shows for example HH:MM:SS for 5PM as 166000, and therefore it fails converting it, because 60 minutes is not valid.

'20181007166000' is not an FME datetime. YYYYMMDD, HHMMSS[.X+][(+/-)zz] or YYYYMMDDHHMMSS[.X+][(+/-)zz] expected. Use a DateFormatter transformer to adjust the format of datetime strings.

any ideas

Hi @rudy_v, I was not able to reproduce the same symptom as yours.

  • What version of FME are you using?
  • Could you please share a minimal Excel file which contains the question date/time value?
  • As an interim workaround, the DateTimeConverter (set 'Yes' to the 'Repair Overflow' parameter) could be used to repair the invalid date/time.

Hi @rudy_v, I was not able to reproduce the same symptom as yours.

  • What version of FME are you using?
  • Could you please share a minimal Excel file which contains the question date/time value?
  • As an interim workaround, the DateTimeConverter (set 'Yes' to the 'Repair Overflow' parameter) could be used to repair the invalid date/time.
using 2018.1, and has set it to yes - will upload file soon

Hi @rudy_v, I was not able to reproduce the same symptom as yours.

  • What version of FME are you using?
  • Could you please share a minimal Excel file which contains the question date/time value?
  • As an interim workaround, the DateTimeConverter (set 'Yes' to the 'Repair Overflow' parameter) could be used to repair the invalid date/time.
@takashi got it to work, but i had a 2003 xls file before, that worked ok, but i have changed the file in the reader to 2010 version xlsx, that failed on even with repair

 

But i have deleted the reader and create from scratch, by using the xlsx file, then it worked OK

 

Community Stats

31,951
Posts
121,336
Replies
39,561
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.