How to import LO Calc date field to LO Base

English
#1

From Calc mm/dd/yyyy :

image description
image description904×128 20.2 KB

The result in Base:
image description
image description1014×180 24.2 KB

Is it correct ?

[Fedora 30 Workstation / Plasma KDE Desktop Environment / LibreOffice Version: 6.2.4.2 / Base with Firebird embedded]

#2

I assume that your representation in Base is a table.
You can set your edit table and format for the date.

image description
image description757×677 27.4 KB

Then choose the date format.

image description
image description800×493 10.9 KB

The separator “/” should be displayed correctly according to the selected language or region.

#3

The format displayed can also be done in Table Data View by right clicking on the field heading and selecting Column Format. Keep in mind this is simple a display. Internally the data is stored in yyyy-mm-dd format regardless of the displayed date.

#4

Thank you so much.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.