SQL date

A place for users to ask each other questions, make suggestions, and discuss Bookends.
Post Reply
jmckeown
Posts: 27
Joined: Thu Aug 26, 2004 6:17 am

SQL date

Post by jmckeown »

Trying to catch items added on a particular date into a search.

In the User Guide I can see dateModified is a field (or an attribute?)
and I am guessing that dateAdded is the term to use?

I tried SQL... dateAdded = '09-11-2009' (for 9 November)
but that gives a search error so I have got something wrong...

regards, John
John McKeown
Jon
Site Admin
Posts: 10291
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: SQL date

Post by Jon »

Hi,

Because of the way the creation date is stored, it's not accessible to third parties. You can add the Added column to your list view and sort by it. That will allow you to quickly find references added between certain dates.

Jon
Sonny Software
Post Reply