The date doesn’t appear in the correct way

1- In the [DATE PENDING DONE] column, I chose DATA as the column type.

2X_2_2ee3a26838481b1de80aa8829510c24a1ddf7ce3.jpeg

2- In the Data entry page, (device or PC). The date for this column appears correct when entering (e.g. 17-10-2019). Gregorian calendar

3- In the excel file, the date doesn’t appear in the correct way (e.g. 17-10-2019). BUT it appears as (18/02/41) Hijri calendar

2X_9_93c455c371a0fffaaadc90537d62ebaee322b186.jpeg

P.S. The device date is Gregorian. Also, the cell formatting is showing Gregorian.

2X_7_706780c4a748d54e595564ddcf1ad01c951e3054.jpeg

Is there a solution.

Solved Solved
0 3 529
1 ACCEPTED SOLUTION

I followed your guidance and now it is working fine.

The problem was in (spreadsheet locale settings). It was empty. So I chose EGYPT.

These are the steps I followed to solve the problem

2X_9_9b24b174d083f0ed6d1a7e664164f08ba19fadeb.jpeg

2X_0_003eb4285a6fd5da16d3504d81ebc1f5ec465a88.jpeg

@Aleksi Thank you very much

View solution in original post

3 REPLIES 3

Have you checked that spreadsheet’s locale settings and settings in the table (app) are correct?

I followed your guidance and now it is working fine.

The problem was in (spreadsheet locale settings). It was empty. So I chose EGYPT.

These are the steps I followed to solve the problem

2X_9_9b24b174d083f0ed6d1a7e664164f08ba19fadeb.jpeg

2X_0_003eb4285a6fd5da16d3504d81ebc1f5ec465a88.jpeg

@Aleksi Thank you very much

You’re welcome

Top Labels in this Space