Date problems from Phemex CSV import

Transactions are showing from dates in the future.

Phemex.

CSV import.

Tried reaching out to support but no answer yet. Is there a date format to adjust?

Thank you!

So after looking into this further it is a simple but pesky date issue.

Transaction from July 1 2021 showing as 7 January 2021 so this is date -month confusion on the CSV import, and pretty sure the rest are the same.

Aside from fact this makes Koinly look like amateur hour on the integration tool, what do I need to do on the CSV date settings to correct everything? If I reset to day-month-year (instead of USA standard month-day-year), erase current and re-import is that going to work? Thank you.

I reset the csv date format to dd-mmm-yyyy and everything worked. Could be helpful for other USA users.

I was having a similar issue with the CSV files not accepting, say “invalid date”. The weird thing was 1 out of the 4 didn’t have to be re-formatted to dd/mm/yyyy hh:mm but the other 3 did.