Skip to main content

Date issue

Feature Request

Subject: Date Format Issue with ThinkorSwim Data Import

Hi,

I'm experiencing a date format issue when uploading data exported from ThinkorSwim into MyPnL.

My spreadsheet correctly shows today's date as 04/08/2026 (MM/DD/YYYY), however MyPnL is interpreting this as 4th August rather than 8th April, suggesting it is reading the date in DD/MM/YYYY format instead.

This appears to affect dates from the 1st through to the 12th of each month — any date where the day value could also be read as a valid month number — and as a result I am having to manually correct the dates on all affected positions after every import, which is time-consuming.

Could you please advise whether there is a date format setting within MyPnL that I can adjust, or whether this is something that can be resolved on your end?

Many thanks

Posted by Gavin Clarke ·
5 comments

Log in to comment and vote

Comments5

  • Gavin Clarke

    •

    Apr 21

    I’ve tried changing the date format in the MyPnL setting I’ve also tried changing the fromat in my csv file. NO LUCK!

    • My PnL

      Team•

      May 18

      is this issue resolved ?

      • Gavin Clarke

        •

        May 19

        I had to use ChatGPT to make a excel template to convert the format to fit in with MyPnL. The MyPnL import feature for thinkorswim dosen’t and hasn’t ever worked!

  • Gavin Clarke

    •

    Apr 9

    Again up loaded yesterdays trades. 8/4/2026 and now is 4/8/2026 on MyPnL! Again another 48 trades I have to change the date on. Please Please please sort this. Let me know if you need my .csv

    • Emmanuel A

      •

      Apr 20

      I have had to change my date format in the settings.