Re: Date Help

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56401
interpreted = N
texte = Can you search the same field (TSDATE) twice? You might be better of using a range instead if not. Pat On 27 Feb 2004, at 14:55, Steve Craig wrote: > Hi > > OK, I am officially going off my head. I have re-used a piece of > otherwise > working code and it's not working and I cannot see why. Basically I > want to > return the timesheet records a given user for the current month. The > records > have a field called TSDATE which is in dd/mm/yyyy (UK Format). I know I > could save these as numbers but would prefer to work in this format. > > (I have put a return in after each & in the search string to save any > funny > returns from the email.) > > [math date]SDate={01/[date %m]/[date %Y]}[/math] - > 01/02/2004 > [math date]EDate={01/[date %m]/[date %Y]}+{00/01/0000}[/math] - > 01/03/2004 > > [search db=admin/-Timesheets.db& > eqTSUserNamedatarq=[USERNAME]& > geTSDATEdatarq=[SDate]& > lsTSDATEdatarq=[EDate]& > asTSDATEsort=1& > TSDATEtype=date] > > > Any help much appreciated, I'm sure its something silly. This code is > just > returning all records for that user. > > Cheers > > Steve Craig > > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ > > --------------------------------------------------------- Netro42 - http://www.netro42.com Web design and development --------------------------------------------------------- Netro42 Limited 39 - 51 Highgate Road London NW5 1RT T: 020 7267 7002 F: 020 7267 7544 E: mailto:patrick.holliday@netro42.com --------------------------------------------------------- ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Date Help - Searching the same field twice ( "Scott Anderson" 2004)
  2. Re: Date Help ( Gary Krockover 2004)
  3. Re: Date Help ( Steve Craig 2004)
  4. Re: Date Help ( Gary Krockover 2004)
  5. Re: Date Help ( Steve Craig 2004)
  6. Re: Date Help ( Brian Fries 2004)
  7. Re: Date Help ( "WebDna @ Inkblot Media" 2004)
  8. Re: Date Help ( Donovan Brooke 2004)
  9. Re: Date Help ( Donovan Brooke 2004)
  10. Re: Date Help ( Pat Holliday 2004)
  11. Re: Date Help ( Gary Krockover 2004)
  12. Date Help ( Steve Craig 2004)
  13. Re: Date Help! (Dan Strong 2003)
  14. Re: Date Help! (Lester Emo 2003)
  15. Re: Date Help! (Dan Strong 2003)
  16. Re: Date Help! (Lester Emo 2003)
  17. Re: Date Help! (Glenn Busbin 2003)
  18. Re: Date Help! (Lester Emo 2003)
  19. Re: Date Help! (Dan Strong 2003)
  20. Re: Date Help! (Lester Emo 2003)
  21. Re: Date Help! (Dan Strong 2003)
Can you search the same field (TSDATE) twice? You might be better of using a range instead if not. Pat On 27 Feb 2004, at 14:55, Steve Craig wrote: > Hi > > OK, I am officially going off my head. I have re-used a piece of > otherwise > working code and it's not working and I cannot see why. Basically I > want to > return the timesheet records a given user for the current month. The > records > have a field called TSDATE which is in dd/mm/yyyy (UK Format). I know I > could save these as numbers but would prefer to work in this format. > > (I have put a return in after each & in the search string to save any > funny > returns from the email.) > > [math date]SDate={01/[date %m]/[date %Y]}[/math] - > 01/02/2004 > [math date]EDate={01/[date %m]/[date %Y]}+{00/01/0000}[/math] - > 01/03/2004 > > [search db=admin/-Timesheets.db& > eqTSUserNamedatarq=[username]& > geTSDATEdatarq=[SDate]& > lsTSDATEdatarq=[EDate]& > asTSDATEsort=1& > TSDATEtype=date] > > > Any help much appreciated, I'm sure its something silly. This code is > just > returning all records for that user. > > Cheers > > Steve Craig > > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ > > --------------------------------------------------------- Netro42 - http://www.netro42.com Web design and development --------------------------------------------------------- Netro42 Limited 39 - 51 Highgate Road London NW5 1RT T: 020 7267 7002 F: 020 7267 7544 E: mailto:patrick.holliday@netro42.com --------------------------------------------------------- ------------------------------------------------------------- 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://webdna.smithmicro.com/ Pat Holliday

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:

MORE: Can I determine where they are coming from? (2000) wrong input values? (1997) WCS Newbie question (1997) SetLineItem (1997) WebCatalog 3.0.8 is on FTP... (2000) cron script for housekeeping and running WebCatalog? (1999) The IBC root beer has arrived! (1997) problems with 2 tags (1997) Major Security Hole (1998) [taxrate] question (1997) WC2.0 Memory Requirements (1997) Re:Searching for ALL / empty form field (1997) Country & Ship-to address & other fields ? (1997) Problems getting parameters passed into email. (1997) Problems with shopping cart (1997) Date subtraction (2002) Separate SSL Server (1997) WebDNA Server (2007) Problems appending to database (1997) WYSIWYG Entry of text fields (2001)