Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date parsing

Hi

I am reading and excell column which stores date. The format i am receiving the date is as below

Thu Apr 02 00:00:00 CDT 2020

 

So i am trying to convert it into date with following statement in tJavaRow componenet

Thu Apr 02 00:00:00 CDT 2020

output_row.effective_date = TalendDate.parseDate("E MMM dd hh:mm:ss z yyyy",input_row.effective_date);

 

But after conversion the date i am receiving is one day before of the day i am receiving, i.e in this case it 01-Apr-2020.

What could be possible reason?

Thanks

Saswata

Labels (2)
1 Reply
akumar2301
Specialist II
Specialist II

You are not in CDT timezone. Date us converted to your local timezone datetime.