Jump to content

Date format of exported receipt

Go to solution Solved by Andy,

Recommended Posts



I tried to use excel pivot table with exported receipt data.

But, the date format of the exported data is not consistent. 

I exported 8/31/2020 and 9/1/2020. Then the date of the 8/31/2020 shows as a text format such as 31/08/2020 09:00 but 9/1/2020 shows as 1/9/2020 09:00 and it shows as date format. So If I tried to converse the date/time to date format I should converse separately. How can I fix this problem? 

Thanks in advance.


I attached screen shot.


Link to comment
Share on other sites

Hi, Andy!


I did it with google sheets. But the result is same.

As you can see it at the attached screen shot, 9/1/20 is shown as a date format and 8/31/20 is shown as a text format.

Is there anything I missed?




Screen Shot 2020-09-07 at 10.04.59 AM.png

Link to comment
Share on other sites

I tried  CSV to XLSX (EXCEL) Converter as recommended with the same result.

As you can see, I transposed the date/time into date with the formula. 

9/1/20 field was transposed as expected.

8/31/20 was not. 

all the date of August showed same result. 



Link to comment
Share on other sites

Thank you for your response. But the result is same.

I need to transpose date/time to date. Whatever formula I used the result is same. September one can be transposed but the August one result in error. 



Link to comment
Share on other sites

Yes. I exported the data for the 8/31/20 thru 9/5/20

and I found out the date format of 8/31/20 and September ones are not identical. 

So when I try to transpose the date/time into date it case the error for 8/31/20.



Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in

Sign In Now

Loyverse Point of Sale





  • Create New...