Dates in LUNA

Dates in LUNA

Introduction

The LUNA Viewer now (7.3+) supports date range searching. To best make use of this feature the date values must be formatted to match one of a number of patterns.

Date Patterns

Below is a list of date patterns followed by an example

Pattern

Example

Note

Pattern

Example

Note

yyyy

1837

 

MM/dd/yyyy

06/24/1837

 

dd MMM yyyy

24 Jun 1837

You can use the full month here

MM/dd/yyyy HH:mm:ss

06/24/1837 17:08:56

 

MM/dd/yyyy hh:mm:ss aa

06/24/1837 5:08:56 PM

 

yyyy-MM-dd HH:mm:ss

1837-06-24 17:08:56

 

yyyy-MM-dd hh:mm:ss aa

1837-06-24 5:08:56 PM

 

yyyy-MM-dd'T'HH:mm:ss'Z'

1837-06-24:17:08:56-0800

The Z is the offset from UTC time -0800 is Pacific Standard Time

yyyy-MM-dd't'HH:mm:ss'z'

1837-06-24:17:08:56PST

The lowercase z is using the name like these three options:

Pacific Standard Time

PST 

 GMT-08:00

 

Other references

Data Templates & Data Schemas to define your date fields.

See Default Date Field in Creating & Editing Collection Properties to choose a single date field that will be used in the simple search box.

See Searching to understand where you can do date range searches.