Excel date column format issue

[gt0731]

. when i am trying to read THE DATE column it is giving me error
any help on it would be much appreciated 

Attached is the  screenshot of job

tarting job DebugTime at 14:46 30/10/2018.

[statistics] connecting to socket on port 3446
[statistics] connected
Exception in component tMap_1 (DebugTime)
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "0030c00002XGcpHAAT"
	at routines.TalendDate.parseDate(TalendDate.java:898)
	at routines.TalendDate.parseDate(TalendDate.java:842)
	at frog_demo.debugtime_0_1.DebugTime.tFileInputExcel_1Process(DebugTime.java:978)
	at frog_demo.debugtime_0_1.DebugTime.runJobInTOS(DebugTime.java:1437)
	at frog_demo.debugtime_0_1.DebugTime.main(DebugTime.java:1286)
Caused by: java.text.ParseException: Unparseable date: "0030c00002XGcpHAAT"
	at java.text.DateFormat.parse(Unknown Source)
	at routines.TalendDate.parseDate(TalendDate.java:884)
	... 4 more
[statistics] disconnected

Job DebugTime ended at 14:46 30/10/2018. [exit code=1]

 Also, attaching exact excel sheet with date column that i want to read here

[Anonymous]

Hello,

What is the source date format? Do youneed to convert date to string?

Best regards

Sabrina

[sunbaj]

I see that your source is string and the target is date. You need to use the following expression to convert string to date. Also make sure that you filter out any nulls or put in a check that if null then ignore else use the below expression

TalendDate.parseDate("yyyy-MM-dd",Var.var1) 

[gt0731]

I am reading source as string type and i want to convert it into date ?
I also attached excelsheet here. please dowanload at your end

[gt0731]

When i tried the this expression it gives me error
Starting job DebugTime at 15:36 01/11/2018.

[statistics] connecting to socket on port 4057
[statistics] connected
java.lang.NumberFormatException: For input string: "003a"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at routines.system.FastDateParser$DateParser.parse(FastDateParser.java:127)
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:884)
at routines.TalendDate.parseDate(TalendDate.java:842)
at frog_demo.debugtime_0_1.DebugTime.tFileInputExcel_1Process(DebugTime.java:979)
at frog_demo.debugtime_0_1.DebugTime.runJobInTOS(DebugTime.java:1438)
at frog_demo.debugtime_0_1.DebugTime.main(DebugTime.java:1287)
Exception in component tMap_1 (DebugTime)
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "003a000001QLYuTAAX"
at routines.TalendDate.parseDate(TalendDate.java:898)
at routines.TalendDate.parseDate(TalendDate.java:842)
at frog_demo.debugtime_0_1.DebugTime.tFileInputExcel_1Process(DebugTime.java:979)
at frog_demo.debugtime_0_1.DebugTime.runJobInTOS(DebugTime.java:1438)
at frog_demo.debugtime_0_1.DebugTime.main(DebugTime.java:1287)
Caused by: java.text.ParseException: Unparseable date: "003a000001QLYuTAAX"
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:884)
... 4 more
[statistics] disconnected

Job DebugTime ended at 15:36 01/11/2018. [exit code=1]

[gt0731]

when i am clicking on cell of excel sheet. it gives me diffrent date format for ex 07/22/2018 34:35:L36 AM

[sunbaj]

Your date format is MM/DD/YYYY HH:ss

[sunbaj]

It seems that there is some issue with the time format. Do check your source.

[gt0731]

I attached my source file . please use the file

[gt0731]

  

Starting job DebugTime at 19:39 01/11/2018.

[statistics] connecting to socket on port 3700
[statistics] connected
java.lang.NumberFormatException: For input string: "003a"
	at java.lang.NumberFormatException.forInputString(Unknown Source)
	at java.lang.Integer.parseInt(Unknown Source)
	at java.lang.Integer.parseInt(Unknown Source)
	at routines.system.FastDateParser$DateParser.parse(FastDateParser.java:127)
	at java.text.DateFormat.parse(Unknown Source)
	at routines.TalendDate.parseDate(TalendDate.java:884)
	at routines.TalendDate.parseDate(TalendDate.java:842)
	at frog_demo.debugtime_0_1.DebugTime.tFileInputExcel_1Process(DebugTime.java:977)
	at frog_demo.debugtime_0_1.DebugTime.runJobInTOS(DebugTime.java:1436)
	at frog_demo.debugtime_0_1.DebugTime.main(DebugTime.java:1285)
Exception in component tMap_1 (DebugTime)
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "003a000001QLYuTAAX"
	at routines.TalendDate.parseDate(TalendDate.java:898)
	at routines.TalendDate.parseDate(TalendDate.java:842)
	at frog_demo.debugtime_0_1.DebugTime.tFileInputExcel_1Process(DebugTime.java:977)
	at frog_demo.debugtime_0_1.DebugTime.runJobInTOS(DebugTime.java:1436)
	at frog_demo.debugtime_0_1.DebugTime.main(DebugTime.java:1285)
Caused by: java.text.ParseException: Unparseable date: "003a000001QLYuTAAX"
	at java.text.DateFormat.parse(Unknown Source)
	at routines.TalendDate.parseDate(TalendDate.java:884)
	... 4 more
[statistics] disconnected

Job DebugTime ended at 19:39 01/11/2018. [exit code=1]