Versions Compared

Old Version 7

changes.mady.by.user Olivia Schütt

Saved on

compared with

New Version Current

changes.mady.by.user Elaine Foley

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excerpt
Include Page
TERMS:Date Time Field
TERMS:Date Time Field

Date Time Overview

Icon

Image Modified

Date Time edit mode

Image Modified

Date &Time Selection

Image Modified

You can click on the date or time in the top area to make your edit. After editing press Apply.

Date time read-only display

Image Modified

Behavior

Attention: you must press the Apply button to save your date and time selection; clicking out of the calendar and time input cancels your choice.

Limitation

The simple search in the content browser cannot find dates. In such a case, we recommend adding a channel filter.

Examples

  • Valid to or Valid from information for copyrights

  • Dates for Events

  • Employee Birthdays

  • Publication dates

  • Review dates

  • Embargo dates

Date Time Value Handling

Picturepark Setup Example

Layer: Corporate Information (ID: CorporateInformation)

Field: Embargo Date (ID: embargoDate)

Fieldpath

corporateInformation.embargoDate

Advanced search for field

Filter by label (Content by label)
showLabelsfalse
cqllabel = "advanced-search" and label = "field" and space = "SOL"

Advanced search for the field value

Filter by label (Content by label)
showLabelsfalse
cqllabel = "advanced-search" and label = "date" and space = "SOL"

Use in Display Pattern

Filter by label (Content by label)
showLabelsfalse
cqllabel in ( "date" , "date-time" ) and label = "display-pattern" and space = "SOL"

Returned field value

returns date as: 2019-12-19T01:02:02.000Z84

Date Time Field Settings

Name

Include Page
TERMS:Name
TERMS:Name

ID

Include Page
TERMS:Field ID
TERMS:Field ID

Checkbox "Date and time."

Enabled: user can input date and time
Disabled: user can only input date

Once set and saved, this cannot be changed!

Set current date/time when creating Items

This will set the current date or date-time when Content Items or List Items which such a field are created. This will also add the current date or date-time to Content Items when a Layer with such a field is added. 

Format

The default format is DD-MMM-YYYY HH:mm:ss.
The format preview is: 27-Dec-2019 22:37:34

D stands for the day, M for the month, Y for the year. H stands for the hour, m for the minute, and s for the second. The number of those characters decides if, e.g., the day shows as 1, Mon, Monday. Sometimes two characters are possible, sometimes not. You can check the underlying JSON Schema definition, or you can play around with the preview directly displayed in the Content Platform: 

field-type_datetime-format-test.mp4

The format setting supports the JSON Schema Date Pattern, e.g., MM/DD/YYYY or DD-MM-YYYY hh:mm:ss. 

Required

Include Page
TERMS:Required
TERMS:Required

UI required

Include Page
TERMS:UI required
TERMS:UI required

Sortable

Include Page
TERMS:Sortable
TERMS:Sortable

Sort items based on the date entered to find the newest or oldest.

Include in filters

Include Page
TERMS:Include In filters
TERMS:Include In filters

Adding Dates or DateTime as a filter would show each single data entry. Therefore dates should be aggregated into periods (ranges), e.g., this week, this month, this year.

Include in search

Include Page
TERMS:Include in search
TERMS:Include in search

The simple search in the content browser cannot find dates. In such a case, we recommend adding a channel filter.

Boost value

n/a