Re: Searching Dates
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35260
interpreted = N
texte = try the works but with a differrent field name - other than date. You should try to avoid using field names that match webcat tags - they can fight.-Johnfrank@usinter.net wrote:> Why do you suppose I get such strange results with this code? I'm just searching a > database for dates, and on months with 30 days, I get results of 31 days. I get the > first day of the next month. If I search for April 2000, I get May 1st in the results. > For months with 31 days I don't have any problem. This should work, yes? Curious... > Webcat 3.0, NT. > > [search db=master.db&rnDATEdatarq=[month]/01/[year] > [month]/31/[year]&DATEtype=date&asDATEsort=1] > [founditems] >
| [date] | [sales] | [commission] | [discount] |
> [/founditems] > [/search] > > Any ideas on what may be wrong? > > Thanks, > > Frank > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
try the works but with a differrent field name - other than date. You should try to avoid using field names that match webcat tags - they can fight.-Johnfrank@usinter.net wrote:> Why do you suppose I get such strange results with this code? I'm just searching a > database for dates, and on months with 30 days, I get results of 31 days. I get the > first day of the next month. If I search for April 2000, I get May 1st in the results. > For months with 31 days I don't have any problem. This should work, yes? Curious... > Webcat 3.0, NT. > > [search db=master.db&rnDATEdatarq=[month]/01/[year] > [month]/31/[year]&DATEtype=date&asDATEsort=1] > [founditems] > | [date] | [sales] | [commission] | [discount] |
> [/founditems] > [/search] > > Any ideas on what may be wrong? > > Thanks, > > Frank > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Butler
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[WebDNA] macOS High Sierra (2017)
Fwd: Problems with Webcatalog Plug-in (1997)
Emailer 1.0.2 Conflicts? (1998)
database size? (1997)
Hard carriage convertion? (1998)
[WebDNA] WebDNA and Google Geo Tagging (2012)
File Uploads... (1997)
Setting up WebCatalog with Retail Pro data (1996)
[delete] problem (1997)
Applescript, WebDNA, and PDF (1997)
PCS Frames (1997)
PCS Frames (1997)
Separate SSL Server (1997)
WCS Newbie question (1997)
Searchable Archives (1998)
access denied problem (1997)
Not reading code (1997)
Shell and telnet (2002)
Need relative path explanation (1997)
[OT] See QT? (Was Eaaaasy FTP...) (2003)