Input Masking query

Megacitizen

Registered User.
Local time
Today, 06:03
Joined
Mar 22, 2012
Messages
130
Quick question

I'm designing a database where numerous dates are input in various fields on my sheet. I see I can set a mask for how the dates can be written, but for some of the entries, only the day and month are necessary (DD/MM), whilst for others the year is also required (DD/MM/YYYY). Do I have to set up my page WITHOUT a mask to be able to achieve this.

Currently, I have one set up with the Date/Time box, at specific locations, reduced in size to fit on my sheet. No matter, which side I reduced size from, the text ended up showing only the year, whereas these boxes are the ones that only require the day and month showing.
 
People at this site will tell you to use the format() function to change how a date is displayed.
 

Users who are viewing this thread

Back
Top Bottom