Select Page
Date (and Time)

Date (and Time)

🔴 On2Air Forms has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com

➡️
The Date and Time field allows you to add a date and time picker to your form and format dates in a specific way.

See more Fields in the Form Field Reference

image
image

How to Add a Field to Your Form

Here’s how to add Airtable Fields or On2Air Custom Fields to your Form

Field Configuration

Field Labels

Title

- Add a title to be displayed above the field as the main name. To leave blank, add a single space

By default, this is the name of your field in Airtable. You can use a different field name than your base and it will not affect the field name in your base.

Sub Title

- Add a subtitle to be displayed above the field. To leave blank, add a single space

You can use text in this field and you can use Markdown to increase text size, bold, or italics

Helper Text

- Add helper text to be displayed below the field. To leave blank, add a single space

You can use text in this field and you can use Markdown to increase text size, bold, or italics

Example:

image
image

Field Status

Select Display Mode

- Determines how this field is displayed on your form

image

  • Optional - Standard Editable Field, but not required
  • Required Field - Standard Editable Field that is required
  • Disabled Field - Standard Field as Non-Editable
  • Display Field - Display the field as Text or other Displayable format
  • Hidden Field - Field is included but not visible to the form user

Field Defaults

Default Value

- Set a default value for this field. A default value is used to automatically add data to the field for the user.

If the field is editable, the default value can be changed by the user.

Set Date Default as Today and/or Now

You can set the Default Date as Today or Now

TODAY() - Will set the date as today and the time at 12:00 PM

NOW() - Will set the date as today and the current time as the exact time of day

Example:

image

Use Default on Edit if Empty

- If enabled, the default value will be used on Record Edits if the field was not completed by the user and has no value

URL Prefill Settings (Pre-Filled Form Fields)

URL Prefills can be used to automatically add data and values to your form fields for your form user

Example: You can send a form to someone with their first and last name and the date already filled in on the form.

There are many ways you can use URL Prefills to make it a more seamless process for your form users.

URL Prefill Key

In On2Air Forms, there is a default key already added to each field that matches the field name. You can change the name or you can leave it as-is. Remove the Key to disable URL Prefills for this field.

image

How to Add a Pre-populated Value to Your Field

  • To add a prefill value to your field, click Set Prefill
  • In the popup, add your value to the corresponding field.
    • If you want to have it pre-populate when someone is creating a form, be sure you add it in Create mode. To pre-populate in Update mode, click Update in the URL Prefill settings and add your value in the corresponding field.

image

  • Click Share Form

image

  • Click Include Prefills

image

  • Your prefill will automatically be added to the URL. You can now share the prefill URL with anyone and the field data will automatically be added to their form.

URL parameters are made of a key and a value after the URL

Key/Value: ?key=value Format: www.on2air.com/form/yourformid?key=value

Date Configuration

Configure Date Format and Locale

Choose how your date is formatted

image

Options:

Short - M/D/YYYY - Example: 3/1/2023

Medium - MMM DD, YYYY - Example: Mar 1, 2023

Full - MMMM DD, YYYY - Example: March 1, 2023

ISO - YYYY-MM-DD - Example: 2023-03-01

Custom - Use formatting syntax listed below - Enter into Custom Date Format field

Custom Date Format - Enter custom date formats

image

Click here to see syntax for Custom Date/Time formats
Standalone token
Format token
Description
Example
S
millisecond, no padding
54
SSS
millisecond, padded to 3
054
u
fractional seconds, functionally identical to SSS
054
uu
fractional seconds, between 0 and 99, padded to 2
05
uuu
fractional seconds, between 0 and 9
0
s
second, no padding
4
ss
second, padded to 2 padding
04
m
minute, no padding
7
mm
minute, padded to 2
07
h
hour in 12-hour time, no padding
1
hh
hour in 12-hour time, padded to 2
01
H
hour in 24-hour time, no padding
9
HH
hour in 24-hour time, padded to 2
13
Z
narrow offset
+5
ZZ
short offset
+05:00
ZZZ
techie offset
+0500
ZZZZ
abbreviated named offset
EST
ZZZZZ
unabbreviated named offset
Eastern Standard Time
z
IANA zone
America/New_York
a
meridiem
AM
d
day of the month, no padding
6
dd
day of the month, padded to 2
06
c
E
day of the week, as number from 1-7 (Monday is 1, Sunday is 7)
3
ccc
EEE
day of the week, as an abbreviate localized string
Wed
cccc
EEEE
day of the week, as an unabbreviated localized string
Wednesday
ccccc
EEEEE
day of the week, as a single localized letter
W
L
M
month as an unpadded number
8
LL
MM
month as a padded number
08
LLL
MMM
month as an abbreviated localized string
Aug
LLLL
MMMM
month as an unabbreviated localized string
August
LLLLL
MMMMM
month as a single localized letter
A
y
year, unpadded
2014
yy
two-digit year
14
yyyy
four- to six- digit year, pads to 4
2014
G
abbreviated localized era
AD
GG
unabbreviated localized era
Anno Domini
GGGGG
one-letter localized era
A
kk
ISO week year, unpadded
14
kkkk
ISO week year, padded to 4
2014
W
ISO week number, unpadded
32
WW
ISO week number, padded to 2
32
o
ordinal (day of year), unpadded
218
ooo
ordinal (day of year), padded to 3
218
q
quarter, no padding
3
qq
quarter, padded to 2
03
D
localized numeric date
9/4/2017
DD
localized date with abbreviated month
Aug 6, 2014
DDD
localized date with full month
August 6, 2014
DDDD
localized date with full month and weekday
Wednesday, August 6, 2014
t
localized time
9:07 AM
tt
localized time with seconds
1:07:04 PM
ttt
localized time with seconds and abbreviated offset
1:07:04 PM EDT
tttt
localized time with seconds and full offset
1:07:04 PM Eastern Daylight Time
T
localized 24-hour time
13:07
TT
localized 24-hour time with seconds
13:07:04
TTT
localized 24-hour time with seconds and abbreviated offset
13:07:04 EDT
TTTT
localized 24-hour time with seconds and full offset
13:07:04 Eastern Daylight Time
f
short localized date and time
8/6/2014, 1:07 PM
ff
less short localized date and time
Aug 6, 2014, 1:07 PM
fff
verbose localized date and time
August 6, 2014, 1:07 PM EDT
ffff
extra verbose localized date and time
Wednesday, August 6, 2014, 1:07 PM Eastern Daylight Time
F
short localized date and time with seconds
8/6/2014, 1:07:04 PM
FF
less short localized date and time with seconds
Aug 6, 2014, 1:07:04 PM
FFF
verbose localized date and time with seconds
August 6, 2014, 1:07:04 PM EDT
FFFF
extra verbose localized date and time with seconds
Wednesday, August 6, 2014, 1:07:04 PM Eastern Daylight Time
X
unix timestamp in seconds
1407287224
x
unix timestamp in milliseconds
1407287224054

Format Locale - The locale for the date. Enter a Language Tag listed below as the locale. Leave blank to use the form users’ locale.

image

Click here to see locale options
Language Tag
Language
Region
Description
ar-SA
Arabic
Saudi Arabia
Arabic (Saudi Arabia)
bn-BD
Bangla
Bangladesh
Bangla (Bangladesh)
bn-IN
Bangla
India
Bangla (India)
cs-CZ
Czech
Czech Republic
Czech (Czech Republic)
da-DK
Danish
Denmark
Danish (Denmark)
de-AT
German
Austria
Austrian German
de-CH
German
Switzerland
"Swiss" German
de-DE
German
Germany
Standard German (as spoken in Germany)
el-GR
Greek
Greece
Modern Greek
en-AU
English
Australia
Australian English
en-CA
English
Canada
Canadian English
en-GB
English
United Kingdom
British English
en-IE
English
Ireland
Irish English
en-IN
English
India
Indian English
en-NZ
English
New Zealand
New Zealand English
en-US
English
United States
US English
en-ZA
English
South Africa
English (South Africa)
es-AR
Spanish
Argentina
Argentine Spanish
es-CL
Spanish
Chile
Chilean Spanish
es-CO
Spanish
Columbia
Colombian Spanish
es-ES
Spanish
Spain
Castilian Spanish (as spoken in Central-Northern Spain)
es-MX
Spanish
Mexico
Mexican Spanish
es-US
Spanish
United States
American Spanish
fi-FI
Finnish
Finland
Finnish (Finland)
fr-BE
French
Belgium
Belgian French
fr-CA
French
Canada
Canadian French
fr-CH
French
Switzerland
"Swiss" French
fr-FR
French
France
Standard French (especially in France)
he-IL
Hebrew
Israel
Hebrew (Israel)
hi-IN
Hindi
India
Hindi (India)
hu-HU
Hungarian
Hungary
Hungarian (Hungary)
id-ID
Indonesian
Indonesia
Indonesian (Indonesia)
it-CH
Italian
Switzerland
"Swiss" Italian
it-IT
Italian
Italy
Standard Italian (as spoken in Italy)
ja-JP
Japanese
Japan
Japanese (Japan)
ko-KR
Korean
Republic of Korea
Korean (Republic of Korea)
nl-BE
Dutch
Belgium
Belgian Dutch
nl-NL
Dutch
The Netherlands
Standard Dutch (as spoken in The Netherlands)
no-NO
Norwegian
Norway
Norwegian (Norway)
pl-PL
Polish
Poland
Polish (Poland)
pt-BR
Portugese
Brazil
Brazilian Portuguese
pt-PT
Portugese
Portugal
European Portuguese (as written and spoken in Portugal)
ro-RO
Romanian
Romania
Romanian (Romania)
ru-RU
Russian
Russian Federation
Russian (Russian Federation)
sk-SK
Slovak
Slovakia
Slovak (Slovakia)
sv-SE
Swedish
Sweden
Swedish (Sweden)
ta-IN
Tamil
India
Indian Tamil
ta-LK
Tamil
Sri Lanka
Sri Lankan Tamil
th-TH
Thai
Thailand
Thai (Thailand)
tr-TR
Turkish
Turkey
Turkish (Turkey)
zh-CN
Chinese
China
Mainland China, simplified characters
zh-HK
Chinese
Hond Kong
Hong Kong, traditional characters
zh-TW
Chinese
Taiwan
Taiwan, traditional characters

Disable the Calendar Date Picker

You can disable the Calendar Date Picker from popping up each time you click the field and allow the user to manually enter in a date.

  • Click Extra Options > Advanced

image

  • Set the showOnFocus setting to false

image

  • The Date Picker will no longer show when clicking in the field

image

Time Formatting

Configure Timezone - Configure how your timezone is displayed on the form

image

Options:

Local Timezone - Display date in user’s local timezone

UTC Timezone - Display date in UTC timezone. Time will be displayed the same for all form users

Specify Timezone - Choose a specific timezone to display for all form users

24 Hour Time - Enable 24 hour time

image

Advanced Options - Mask, Inline

  • Use Mask - Add a date mask pattern to ensure your field follows a specific format. Enter as 9999
  • Example: To format your date as 03-15-2023, you can add a mask of 99-99-9999 to ensure it’s entered exactly as you need

  • Inline Display - Display a calendar inline on your form

image

Limit Dates Available to a Specific Timeframe

You can set a limit on what dates and times are available to choose.

Example: You want to limit dates available to no more than 2 weeks away

image

  • In your Date/Time field options, click Extra Options then click View Advanced Options

image

You’ll see various date and time options to customize. You can use the Relative date options so the days are always relative to the current date.

relMinDate - set a negative number value to allow days prior to Today - Set to 0 to start Today as an option - example: -10 would allow 10 days prior to Today

relMaxDate - set a number value equal to the days past Today that - example: enter 14 for 14 days past Today

disabledDates - disable specific dates so the user cannot choose the date - for multiple dates, add a comma in between dates

- example format: 12/25/2023,12/26/2023,12/27/2023

disabledDays - disable specific days of the week so the user cannot choose the day

enter in the day as a number - format: 0=Sunday, 1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday - Example: 0,6 would remove Sunday and Saturday

- for multiple days, add a comma in between days

minDate - set a static date value as the minimum date to choose from - example: 6/15/2023

maxDate - set a static date value as the maximum date to choose from - example: 7/15/2023

image

Extra Options (Advanced)

There are multiple more Date and Time formatting options for even further customization, such as minimum and maximum dates, week number, seconds, milliseconds, disable days/months, etc. For specific questions on date and time formatting, feel free to reach out to Support.

See all Date options available -

  • Click Extra Options > Advanced to display and edit options
  • image

Danger Zone

Delete your field from the form

  • Click Danger Zone
  • Click Remove

image

  • Click Yes, I want to delete this field from the form

image