(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Date Retrieve Spec
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Date Retrieve Spec (Read 853 times)
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Date Retrieve Spec
Dec 13th, 2010 at 3:31am
Print Post Print Post  
Hi -

I am having a problem creating retrieve specs for dates (in date fields).

I want to be able to pull up all the records for either a given year and/or a given month.

For the year I have tried using e.g. ..1935.. in the universal search and also in the date field itself and neither gives me the result I need.  Can you enlighten me, please.  Thanks!

     - Spencer
  
- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
WWW WWW  
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Date Retrieve Spec
Reply #1 - Dec 13th, 2010 at 2:03pm
Print Post Print Post  
For a year, like 1935, you can either  enter a range or use wildcards with the YYYY/MM/DD internal format.
Range: 01-01-1935..12-31-1995
Wildcard: ]1935/??/??

Note that on the wildcard search, the leading ] tells Sesame to search the field as if it was text, meaning the date value will use the internal YYYY/MM/DD format. The ? wildcard means "any single character". You can use the same technique to find all the records for May, regardless of year.

]????/05/??
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Date Retrieve Spec
Reply #2 - Dec 13th, 2010 at 4:35pm
Print Post Print Post  
Erika -

I used "dots" for wildcards and it didn't occur to me (perhaps I just didn't remember) to try the same "formula" we used in Q&A.  Thanks, much.

   
  
- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
WWW WWW  
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Date Retrieve Spec
Reply #3 - Dec 13th, 2010 at 5:09pm
Print Post Print Post  
SpencerWulwick wrote on Dec 13th, 2010 at 4:35pm:
I used "dots" for wildcards and it didn't occur to me (perhaps I just didn't remember) to try the same "formula" we used in Q&A.  Thanks, much.


Just FYI: .. and ? are both valid wildcards.

.. means "any number of characters"
? means "any single character"
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Date Retrieve Spec
Reply #4 - Dec 13th, 2010 at 5:22pm
Print Post Print Post  
Erika -

Thanks for adding that.  Then my original retrieve spec of  ..1935.. works just fine.   What was missing was the leading bracket        ]..1935..
  
- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge