Date Data

Description

Allows editing of dates with a date picker pop-up menu, or via keying in directly into the fixed format field.

See the Collecting and Displaying Data in a Structured Way guide as an example of how to use this macro.


Parameters

NameRequiredAvailable InMigratable to Cloud?Default ValueDescription
[default] / name (Field Name)
 Yes
Server, Data Center
No
The name of the date data field. Must be unique.
required
 Yes
Server, Data Center
No
false/unchecked
If checked, this field cannot be empty.
minDate (Minimum Date)
 Optional
Server, Data Center
No
The minimum date that is allowed, format of date entered here must follow the format parameter. Default format is 'yyyy-MM-dd'.
maxDate (Maximum Date)
 Optional
Server, Data Center
No
The maximum date that is allowed, format of date entered here must follow the format parameter. Default format is 'yyyy-MM-dd'.
format (Display Format)
 Optional
Server, Data Center
No
yyyy-MM-dd

The format to display the date in. May contain any of the following special characters:

  • y - The year (eg. 'yy' = '05', 'yyyy' = '2005').
  • M - The month (eg. 'MMMM' = 'April', 'MMM' = 'Apr', 'MM' = '04').
  • d - The day (eg. 'dd' = '09', 'd' = '9').
  • H - The hour - 24 hour time (eg. 'HH' = '13').
  • h - The hour - 12 hour time (eg. 'h' = '1', 'hh' = '01').
  • m - The minute (eg. 'mm' = '23').
  • s - The second (eg. 'ss' = '14').
  • a - AM/PM (eg. 'a' = 'PM').


Notes

Version 8.21.9 and below, the date and time is saved and viewed as server time.

For version 8.22.0 and above, Date data macro will always save and display the date and time according to the user's timezone.
When users from different timezone view the saved date and time, it will be displayed as per the viewers' timezone.
The default view for Date data macro will include the time zone.

Tutorial Examples

Solutions
Apps

Resources
Company