Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.

If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping

Answers may be delayed for posts that do not include sufficient information.

daterange assistance

Hi, I see that you have made dateranges easier/more intuitive by including features like "mid” 20th century and "late” 1920s, in your daterange documentation:

"Early/mid/late dates
As of version 1.7.7 it is possible to qualify decade and century dates and date ranges with "early", "mid" and "late" modifiers. CollectiveAccess will interpret "early" centuries expressions as being between the start of the century and the 21st year. Eg. "Early 18th Century" will be stored as 1 January 1700 - 31 December 1720. "Late" dates are considered to be between the 81st year and the end of the century. Eg "Late 18th Century" will be stored as 1 January 1780 - 31 December 1799. "Mid 18th Century" will be stored as 1 January 1740 - 31 December 1760. For decades are treated similarly: "Early 1920s" is stored as 1 January 1920 - 31 December 1923. "Mid 1920s" is stored as 1 January 1923 to 31 December 1927. "Late 1920s" is stored as 1 January 1926 to 31 December 1929.

The rules for mapping early, mid and late ranges to concrete dates are current built into the parser and cannot be changed. They may be made configurable in future versions."

My question is about some inconsistencies that I have found when attempting to hard type a specific daterange, (e.g. '1923-1999' saves as: 'mid 1920s-late 1990s'). This is especially challenging when attempting to record artist life dates. For a brief demonstration, I went through the 1920s-1999:
typed saved as
1920-1999 1920-1999
1921-1999 1921-1999
1922-1999 1922-1999
1923-1999 mid 1920s-late 1990s
1924-1999 1924-1999
1925-1999 1925-1999
1926-1999 late 1920s-late 1990s
1927-1999 1927-1999
1928-1999 1928-1999
1929-1999 1929-1999

1920s-1990s 1920-1999
Early 1920s – late 1990s 1920-1999
Mid 1920s – late 1990s Mid 1920s – late 1990s
Late 1920s- late 1990s Late 1920s- late 1990s
early 1920s-1999 1999
Mid 1920s-1999 1999
late 1920s-1999 1999
1923-1990s 1923- December 31 1999

In many ways this is a very cool feature, however I am struggling to rectify some of the apparent inconsistencies. For example an object made circa 1926-1999 is clear and understandable if read “late 1920s-late 1990s”. However for and artist born in 1926-died in 1999, it is not so understandable for their dates to read, “late 1920s-late 1990s”.

I’m in CA- 1.7.8 if that is at all helpful. I cleared my cache on my computer before testing this. Apparently there is also a server cache(?), I can ask to have that cleared and re-test if you think that may be the culprit.

Thanks for any feedback you may offer, and also for adding the early-mid-late century feature! I am going to try to put this in action!


  • It's there for historical societies that seem to like this sort of thing. If you want to get dates returned as entered try setting the "dateFormat" in datetime.conf to "original"

  • Thanks! Before I break something, does changing "dateFormat = original", does that mean that If I type "1/4/2020", Providence will save as "1/4/2020" and if I type "1900-1999", it will save as such, and not auto format to "January 4 2020" and "20th century" respectively? However I can still type "20th century" for the computer to read "1900-1999" and etcetera?

    Just want to understand ramifications before making an alteration.


  • The change will force all dates to be displayed as originally entered.

  • Thanks!

Sign In or Register to comment.