Ask Your Question

How to import LO Calc date field to LO Base

asked 2019-06-22 07:55:37 +0100

lonk gravatar image

updated 2019-06-22 07:57:01 +0100

From Calc mm/dd/yyyy : image description The result in Base: image description Is it correct ?

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-22 08:31:05 +0100

ebot gravatar image

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

image description

Then choose the date format.

image description

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

edit flag offensive delete link more



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.

Ratslinger gravatar imageRatslinger ( 2019-06-22 17:16:48 +0100 )edit

Thank you so much.

lonk gravatar imagelonk ( 2019-06-24 17:27:54 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-22 07:55:37 +0100

Seen: 40 times

Last updated: Jun 22