We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is it possible to make an input mask for dates in base? [closed]

asked 2018-10-31 02:28:44 +0200

dougmn gravatar image

updated 2021-05-27 14:02:10 +0200

Alex Kemp gravatar image

Is it possible to set things up so that to enter a date so that the user would see something like this: Date __ /__ /__

and be able to hit just the number keys corresponding to the date, such as: 102918

which would be displayed as: 10/29/18

It would be okay with me if this could be set up in the design of the table, or in the design of data entry forms.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-27 14:02:18.642493

1 Answer

Sort by » oldest newest most voted

answered 2018-10-31 03:08:01 +0200

Ratslinger gravatar image


The format of the date will need to correspond with the format you have enabled in the table definition. With that said, you would use a Pattern Field on the form for this. In the field properties set the Literal Mask to __/__/__ and the Edit Mask to NNLNNLNN. Your Date would be a label not part of the entry.

For more information on this please see the LO documentation -> LibreOffice Base Handbook. Chapter 4 - Forms, Pattern field.

edit flag offensive delete link more


Great, that works. I'm sorry, I have the handbook, but had not read about pattern fields. My mind was stuck on dates and text boxes. Thank you for your answer. I'll mark this as solved.

dougmn gravatar imagedougmn ( 2018-10-31 03:34:13 +0200 )edit

Not a problem. Just glad you have what you need.

Ratslinger gravatar imageRatslinger ( 2018-10-31 03:39:58 +0200 )edit

Question Tools

1 follower


Asked: 2018-10-31 02:28:44 +0200

Seen: 535 times

Last updated: Oct 31 '18