# Dates are different in SeaTable and exported XLSX file

**URL:** <https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365>\
**Category:** Troubleshooting\
**Tags:** date-and-time\
**Created:** [May 9, 2023, 12:09pm UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365 "2023-05-09T12:09:16Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vincent](https://forum.seatable.com/user_avatar/forum.seatable.com/vincent/32/2568_2.png) [@Vincent](https://forum.seatable.com/u/Vincent)\
**Post date:** [May 9, 2023, 12:09pm UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365/1 "2023-05-09T12:09:16Z")

</div>

Hello, we notice when we do an excel export of a table, that the date are different.  
The date in excel is 1 day older than the date in the table.

Sea the attach file.

 ![2023-05-09 14_01_21-Test - date_Table1 - Mode protégé - Excel](https://forum.seatable.io/uploads/default/original/2X/9/91dd72fa84f23e673f747e0edc238aa5db4ef9a1.png)

---

<div class="post-metadata">

**Author:** ![daniel.pan](https://forum.seatable.com/user_avatar/forum.seatable.com/daniel.pan/32/13_2.png) [@daniel.pan](https://forum.seatable.com/u/daniel.pan)\
**Post date:** [May 9, 2023, 12:40pm UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365/2 "2023-05-09T12:40:37Z")

</div>

> [@Vincent](#):
>
> Hello, we notice when we do an excel export of a table, that the date are different.  
> The date in excel is 1 day older than the date in the table.

It is likely caused by the timezone settings in dtable\_web\_setting.py. You can change it to match the timezone of your server.

---

<div class="post-metadata">

**Author:** ![Vincent](https://forum.seatable.com/user_avatar/forum.seatable.com/vincent/32/2568_2.png) [@Vincent](https://forum.seatable.com/u/Vincent)\
**Post date:** [May 9, 2023, 1:10pm UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365/3 "2023-05-09T13:10:45Z")

</div>

I dont have any timezone settings in this file.

Can you help me to give me the settings to add timezone settings.

Thanks.

---

<div class="post-metadata">

**Author:** ![Vincent](https://forum.seatable.com/user_avatar/forum.seatable.com/vincent/32/2568_2.png) [@Vincent](https://forum.seatable.com/u/Vincent)\
**Post date:** [May 9, 2023, 1:14pm UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365/4 "2023-05-09T13:14:48Z")

</div>

here is my dtable\_web\_settings.py:

```auto
root@seatable:/opt/seatable/seatable-data/seatable/conf# nano dtable_web_setting s.py
  GNU nano 5.4 dtable_web_settings.py
        'BACKEND': 'django.core.cache.backends.locmem.LocMemCache',
    },
}
COMPRESS_CACHE_BACKEND = 'locmem'

SECRET_KEY = 'xxxxxx'

# for dtable-server
DTABLE_PRIVATE_KEY = 'xxx'
DTABLE_SERVER_URL = 'https://seatable.symta.fr/dtable-server/'
DTABLE_SOCKET_URL = 'https://seatable.symta.fr/'

# for dtable-web
DTABLE_WEB_SERVICE_URL = 'https://seatable.symta.fr/'

# for dtable-db
DTABLE_DB_URL = 'https://seatable.symta.fr/dtable-db/'

# for dtable-storage-server
DTABLE_STORAGE_SERVER_URL = 'http://127.0.0.1:6666/'

NEW_DTABLE_IN_STORAGE_SERVER = True

# for seaf-server
FILE_SERVER_ROOT = 'https://seatable.symta.fr/seafhttp/'

ENABLE_USER_TO_SET_NUMBER_SEPARATOR = True

PLUGINS_REPO_ID='f59784a8-92b4-49b8-bb95-1b38e54b9ee0'

# onlyoffice
ENABLE_ONLYOFFICE = True
ONLYOFFICE_APIJS_URL = "https://SEATABLE_SERVER_HOSTNAME/onlyofficeds/web-apps/apps/api/documents/api.js"
ONLYOFFICE_FILE_EXTENSION = ('doc', 'docx', 'ppt', 'pptx', 'xls', 'xlsx', 'odt', 'fodt', 'odp', 'fodp', 'ods', 'fods', 'csv', 'ppsx', 'pps')
ONLYOFFICE_JWT_SECRET = 'secretjwttoken'

# SAML SSO
ENABLE_SAML = True
SAML_REMOTE_METADATA_URL = 'https://login.microsoftonline.com/xxx>
SAML_PROVIDER_IDENTIFIER = 'azure'
#SAML_CERTS_DIR = '/shared/ssl/'

#SAML_PROVIDER_DOMAIN = 'azure.saml'
# 'Key' is the user attribute of Azure SAML, 'value' is the user attribute of SeaTable. The uid attribute of SeaTable is required.
SAML_ATTRIBUTE_MAP = {
    'uid': 'uid',
    'mail': 'contact_email',
    'name': 'name',
    'employeeid': 'employee_id', # Syncing user's employee ID from SAML
    'jobtitle': 'user_role', # Syncing user's role from SAML
}

#Envoi de mail
EMAIL_USE_TLS = False
EMAIL_HOST = '172.16.1.252' # smpt server
EMAIL_HOST_USER = 'seatable@symta.fr' # username and domain
EMAIL_HOST_PASSWORD = '' # password
EMAIL_PORT = 25
DEFAULT_FROM_EMAIL = EMAIL_HOST_USER
SERVER_EMAIL = EMAIL_HOST_USER

```

---

<div class="post-metadata">

**Author:** ![rdb](https://forum.seatable.com/user_avatar/forum.seatable.com/rdb/32/1869_2.png) [@rdb](https://forum.seatable.com/u/rdb)\
**Post date:** [May 9, 2023, 4:07pm UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365/5 "2023-05-09T16:07:52Z")

</div>

You can add

```auto
TIME_ZONE = 'UTC'

```

or

```auto
TIME_ZONE = 'Europe/Paris'

```

to your `dtable_web_settings.py`.

---

<div class="post-metadata">

**Author:** ![Vincent](https://forum.seatable.com/user_avatar/forum.seatable.com/vincent/32/2568_2.png) [@Vincent](https://forum.seatable.com/u/Vincent)\
**Post date:** [May 10, 2023, 9:26am UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365/6 "2023-05-10T09:26:23Z")

</div>

Thanks for your help 🙂

---

<div class="post-metadata">

**Author:** ![rdb](https://forum.seatable.com/user_avatar/forum.seatable.com/rdb/32/1869_2.png) [@rdb](https://forum.seatable.com/u/rdb)\
**Post date:** [May 10, 2023, 11:56am UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365/7 "2023-05-10T11:56:37Z")

</div>

Your problem solved?

---

<div class="post-metadata">

**Author:** ![Vincent](https://forum.seatable.com/user_avatar/forum.seatable.com/vincent/32/2568_2.png) [@Vincent](https://forum.seatable.com/u/Vincent)\
**Post date:** [May 10, 2023, 12:40pm UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365/8 "2023-05-10T12:40:05Z")

</div>

Yes ! The problem is solved. Thanks

---

<div class="post-metadata">

**Author:** ![system](https://forum.seatable.com/uploads/default/original/1X/04603423fe81a46c321283663086c475429e8ccb.png) [@system](https://forum.seatable.com/u/system)\
**Post date:** [May 12, 2023, 12:40pm UTC](https://forum.seatable.com/t/dates-are-different-in-seatable-and-exported-xlsx-file/2365/9 "2023-05-12T12:40:26Z")

</div>

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.