Input Date | Click in this field to select a date from the calendar that opens and optionally set a time. Click Now to pick the current date and time. |
Output Date Type | Select the data type to apply to this date: Date = the value for this date and time, if any, are treated as a date. It can be used in date calculations or sorting by date. String = the value for this date and time, if any, are treated as a string of text. You cannot use this value in date calculations or sorting. You can choose the format to use to display this date string. |
Output Date Format | Select the format to apply to this date string. Date formats include: Date and time syntax symbols includes: a = AM or PM for 12-hour times dd = 2-digit date of the day EEE = 3-character abbreviation of the day of the week, such as Thu EEEE = full name of the day of the week, such as Thursday HH = 2 digit hour in a 24 hour clock hh = 2 digit hour in a 12 hour clock MM = 2 digit month MMM = 3-character month abbreviation, such as Dec MMMM = full month by name, such as December mm = minutes ss = seconds sss = milliseconds yyyy = 4-digit year z = timezone |