Ask Your Question
0

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: 6.2.4.2 / Base with Firebird embedded]

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

Comments

2

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

Stats

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

Seen: 40 times

Last updated: Jun 22