CELEX – Date of Publication Field (pub)


The Date of Publication field in the CELEX database on Justis is part of the Default group and of the DATE group, and contains the date of publication in the Official Journal. For example:

Date of Publication     1999/07/22

In the Outline, this field is called “Date of Publication”.

In documents, this field is shown as “Date of Publication”.

If you want to use the Date of Publication field on the Quick Search screen or in the Full Text box on the Search In EU screen, its name is “pub”, and you can use a search such as:

pub[on 20010310] and form[treaty]

You can search this field for a range of dates in a number of formats. Date range searching is controlled by the date operators: AFTER, BEFORE, ON, FROM and TO. Use FROM and TO if you want to specify a range by its start and end dates.

Pub[after 1 jan 1998] finds documents dated after 1 January 1998
Pub[before 18/01/1998] finds documents dated before 18 January 1998
Pub[on jan 3 1998] finds documents dated 3 January 1998
Pub[from 1 jan 1997 to 31 dec 1997] finds documents dated from 1 January 1997 to 31 December 1997, inclusive of both dates

You can use symbols to represent some date operators:

>     represents     AFTER
<     represents     BEFORE
=     represents     ON

You can search for dates in the following formats:

Format Example
dd/mm/yyyy
dd mmm yyyy
dd mmmm yyyy
mmm dd yyyy
mmmm dd yyyy    
yyyy/mm/dd
yyyymmdd
17/12/1997
17 dec 1997
17 december 1997
dec 17 1997
december 17 1997
1997/12/17
19971217

Names of months can be in full, or 3-letter abbreviations (with or without a full stop), with or without an initial capital. Dates that begin with the names of months can optionally have a comma after the day.

Used in the Treaties database (Sector 1), the External Agreements database (Sector 2), the Legislation database (Sectors 3 and 4), the Proposals database (Sector 5), the Parliamentary Questions database (Sector 9), the OJC Documents database (Sector C), and the EFTA Documents database (Sector E).



cxe-fields-pub.html; last updated 27th September 2007
Copyright © 2006–2007 Justis Publishing Limited

Contents Index Back Forward Close Top Contents Close