Bank statement imports date not picked up from the actual statement

(0) Share

Report

Posted on by Claire999

the dates I would like to see is 09/03/2022 but instead it is displaying a date of 09/01/2022. My working date is 14/03/2022 so that's also not related. Where does the 09/01/2022 originates ?

Thanks

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

JAngle 159 on at

Like (1)

Report
Copy link

Link copied!

I’d check the data exchange definition being used. Date format for en-GB should be did/MM/yyyy it is case sensitive. Lower case m for this is for time based data

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Sorry, I tried to find the answer in the source code of this page and table in BC19.5, but I only found "Transaction Date" := WorkDate;. This is obviously different from your test result, hope someone else can give you more advise.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Claire999 92 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your effort, changing the date format from dd/mm/yyyy to dd/MM/yyyy solved the issue.

Was this reply helpful? Yes No