Date Format in Configuration Worksheet

(0) Share

Report

Posted on by subrata.bauri

1,144

Dear Sir,

I'm working in NAV 2016 CU26 Version. The date format I have seen in the data(exist) in the database is DD/MM/YYYY. I am using Configuration Worksheet for data import & export. The different date format MM/DD/YYYY is found in the exported excle file.

I want the same date format should be exported while exporting into excel using Configuration Worksheet.

How do I set/correct this kind of issue ?

Regards,

Subrata Bauri

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

I think it depends on your Excel date format (system culture).

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report

Export to Excel Using Excel Buffer is giving exact date(format) from database.

No special formation is used here.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

What is your date format in your Windows system? DD/MM/YYYY or MM/DD/YYYY?

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

Hi SUBRATA,

I think it is not an issue. It depends on date format of client. When date format of client is DD/MM/YYYY, excel displays date values in DD/MM/YYYY format. Same for MM/DD/YYYY.

Some global customers, using same system, French employees use DD/MM/YYYY format + US employees use MM/DD/YYYY.

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report

I am testing the same in (Live) Server... (where NAV server is installed).

Date format in Window system is DD/MM/YYYY

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report

Hi Khoa Nguyen,

Date format of the Client(Window system) is DD/MM/YYYY. While exporting data into excel file using Configuration Worksheet the date format is MM/DD/YYYY

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi SUBRATA,

I tested with Sales Header, default format for exporting is "yyyy-MM-dd" as below picture.

Replace config. package function's objects with standard objects may help you (remember to backup before replacing).

Was this reply helpful? Yes No