Unable to parse Date CSV Imports - Due Date filed

Keith Conklin December 14, 2022

I am using the dd/Mmm/yy format - it works fine for target start and target end dates but not the Due field. It says unable to parse date no matter what format I use?

3 answers

2 accepted

0 votes
Answer accepted
Keith Conklin December 16, 2022

So I found the issue - have to remove the h:mmm from the config file format

Parveen Vats June 28, 2023


Screenshot 2023-06-28 200512.png

Why am I not able to parse due dates? Format of  Target Start and Due date is same. 
Target Start is going fine but due dates..showing unable to parse
Any guesses ? PL help


0 votes
Answer accepted
Tansu Akdeniz
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 14, 2022

Hi @Keith Conklin 

Welcome to the community.

Please compare the date formats in csv for target start/end & due date. If format is identical, both columns should be imported as expected since there is no problem for target dates.

ps: I personally use 14-12-2022 / dd-MM-yyyy format for imports.

Keith Conklin December 14, 2022

Thanks Tansu

The format used in target start/end are identical to that used in due date, check ed by 3 people. Still cannot import to due date field

0 votes
Keith Conklin December 14, 2022

Thanks for the response, the date formats in both fields are identical, and have been checked by 3 people, target start/end imports fine, due date does not says unable to parse date.

Suggest an answer

Log in or Sign up to answer