Two Date format in Receipts by item monthly report

[rsjvicky]

Hi,

Receipts by Item monthly report has two date formats. first 12 days have Custom d/m/y hh:mm date format, white the remaining days have General format.

If affecting my integration of reports 

Edited February 5, 2022 by rsjvicky

[Andy]

Hello. Please, check the settings of the program that opens the CSV file. Try to use Google Spead Sheet for opening CSV files. 

[rsjvicky]

Getting the same change in format for dates while opening the csv file in google sheets

Edited March 5, 2022 by rsjvicky

[rsjvicky]

same issue still present

[Sam]

Hello there! 

If you would like to change the date format of your exported reports, it will depend on the regional and language settings on your PC. Please try changing the following setting from your PC to the date format that you prefer.

I hope this was helpful!

[WelkomPaintball]

It seems like I had the same issue but found that it was Macbook Microsoft Excel formatting issue specifically.

Edited February 25, 2024 by WelkomPaintball