Export to Excel-CSV file -> Date format require is MM/YYYY

Business Central/NAV User Forum
1

Dear all,

I need to export G/L Entries posting date to CSV file in this date format MM/YYYY (e.g. 01/2008). Can anyone help?

Thank you very much.

Best regards,

YK Cheong

2

Hi,

You can use FORMAT command:

FORMAT(“Posting Date”, 0, ‘<Month,2>/’)

Cheers,

Viktoras

3

Dear Viktoras,

Thank you for your advice. I tried your method but when I export Jan 2008 data to excel, the system shows as Jan-08 instead of 01/2008.

Best regards,

Cheong

4

Have you looked to CSV file using Notepad?

I think that in file you have 01/2008, but Excel shows Jan-08.

Viktoras

5

The “problem” is Excel, not NAV.

But when exporting, take a look at Automation ‘Microsoft Excel 11.0 Object Library’.Range, that has property NumberFormat.

Or look into table 370, function CreateSheet; search for “Numberformat”.