Jump to content
  • 0
K

Date format of exported receipt

Question

Hi,

 

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.

sample.png

Share this post


Link to post
Share on other sites

8 answers to this question

Recommended Posts

  • 0

thanks. i'll try it.

 

Share this post


Link to post
Share on other sites
  • 0

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?

 

Thanks

 

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

Share this post


Link to post
Share on other sites
  • 0

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. 

 

94491545_ScreenShot2020-09-07at10_13_53AM.png.de1cd22028e1e99fec5d18a186e17f13.png

Share this post


Link to post
Share on other sites
  • 0

While opening CSV in google sheets, pay attention to keeping text format for all cells:

In the Import file settings window, select ‘No’ for ‘Convert text numbers and dates’, and then click on the ‘Import data’ button.

1828008545_googlesheets13(1).jpg.68261083dfb14a6ec0ca9273caaa8b55.jpg

Share this post


Link to post
Share on other sites
  • 0

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. 

 

 

Share this post


Link to post
Share on other sites
  • 0

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.

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Sign in

Already have an account? Sign in here.

Sign In Now

Loyverse Point of Sale

 

 

 

 

×
×
  • Create New...