Searching on Date/Time

3DSpace provides six different formats for the display and entry of dates and times. Each can be modified by adding lines to the .ini file or the startup scripts. For more information, see the Collaboration and Approvals Administration Guide: Calendar and Date Properties.

If your Date/Time query does not conform to the expected format, you will receive an error message similar to the following:

Invalid date/time format ‘July 22. ‘02’. 
Allowed formats are: 
[day] mon dom, yr4 h12:min[:sec] [mer] [tz] 
[day] mon dom, yr4 
moy/dom[/yr2] h12:min[:sec] [mer] 
moy/dom[/yr2]

When entering a date as a value in the Where clause box, 3DEXPERIENCE platform assumes the time is 12:00 AM unless a specific time is specified as part of the query.

The following table explains the tokens used in Date formats:

Token	Means
day	Day of the week (Mon, Tue, Wed,...)
DAY	Day of the week, not abbreviated
mon	Month (Jan, Geb, Mar,...)
MON	Month, not abbreviated
tz	Time zone (edt, cdt, pdt,...)
TZ	Time zone, not abbreviated
mer	Time meridian (am, pm, or blank for 24 hour time)
sec	Seconds, 0 - 59
min	Minutes, 0 - 59
h12	Hour in 12 hour format, "mer" will be non-blank
h24	Hour in 24 hour format, "mer" will be blank
yr2	Abbreviated year (96, 97, 98,...)
yr4	Full year (1996, 1997, 1998..)
dom	Day of month (1, 2, 3,..., 31)
doy	Day of year (1, 2, 3,..., 365)
moy	Month of year (1, 2, 3,..., 12)