Small and medium business | Business Central, N...

Business central - date formatting in CSV

(2) Share

Report

Posted on by PC-03070839-0

Hi Team,

I need to export few fields in payment journals into csv file. document date is getting exported as 11/6/2025 but we need 11/06/2025.

Can you please suggest the ways i can export date as expected.

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 299,881 Super User 2025 Season 2 on at

Like (2)

Report

Business central

Moved the question from the Dynamics 365 General to the Dynamics 365 Business Central forum.

I also updated the title to let volunteers know the contents of the question. Just "Business Central" is too generic.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 13,127 Super User 2025 Season 2 on at

Like (1)

Report

Business central - date formatting in CSV

Hello,

To export the Document Date from Payment Journals in the DD/MM/YYYY format (e.g., 11/06/2025) in Business Central, you can format the date using AL code in a custom report or XMLport with FORMAT("Document Date", 0, '<Day,2>/<Month,2>/<Year,4>').

If you're exporting to Excel, apply a custom date format (dd/mm/yyyy) in Excel itself. For data exchange or page extensions, ensure the date is formatted before writing to the CSV.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 8,794 on at

Like (2)

Report
Business central - date formatting in CSV

Hi @PC-03070839-0,

CSV is plain text, so as far as I know you might output the date as text already formatted as dd/mm/yyyy before saving in CSV.

Workaround: Convert Date to Text Before Saving CSV (No Customisation-And as per my knowledge and trial)
Here’s a step-by-step workaround that ensures the date is exported as dd/mm/yyyy with leading zeros:
Step 1: Use a formula to convert date to text
In a new column (e.g., Formatted Date), enter:
=TEXT(A2, "dd/mm/yyyy")

Replace A2 with the cell containing your original date.

This will show 11/06/2025 instead of 11/6/2025.

Step 2: Copy and Paste as Values

Select the entire Formatted Date column.

Right-click → Copy.

Right-click again → Paste Special → Values.

This replaces formulas with actual text values.

Step 3: Delete the original date column (optional)
This ensures only the correctly formatted date is exported.
Step 4: Save as CSV
Go to File → Save As → CSV (UTF-8).
Now the date will appear as 11/06/2025 in the CSV file, not 11/6/2025.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 30,393 Super User 2025 Season 2 on at

Like (1)

Report

Business central - date formatting in CSV

Can you provide more information, how are you exporting to a CSV file? Did you create a custom export or are you using data exchange definitions?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No