Re: Date Help

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56402
interpreted = N
texte = Hi Steve, Just for that user eh? Try: [math]SDate[/math] and [math]EDate[/math] in the search peram instead of [SDate] and [EDate] (Also, add an "&Allblnk=T" to the search peram to make it return none, if any of the equations are blank.) Cheers, Donovan 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 -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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)
Hi Steve, Just for that user eh? Try: [math]SDate[/math] and [math]EDate[/math] in the search peram instead of [SDate] and [EDate] (Also, add an "&Allblnk=T" to the search peram to make it return none, if any of the equations are blank.) Cheers, Donovan 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 -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/ Donovan Brooke

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:

access denied problem (1997) [WebDNA] [OT] Twitter/Facebook (was: talklist & twitter) (2009) Add all products to cart at once? (1997) passwords (2000) Calendar using WebCatalog? (1997) Unexpected error (1997) Cookies and webcat (1997) WebCat2 Append problem (B14Macacgi) (1997) What if SSL server down? MAC (1997) [WebDNA] [OT] Merchant Provider Suggestions (2008) Emailer (1998) Credit card types (1997) [WebDNA] WebDNA vs. PHP code examples (2008) Items XX to XX shown (1997) [WebDNA] WebDNA7 and mod_fcgi (2013) WebCat2 beta 11 - new prefs ... (1997) development check... (2004) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) [WebDNA] WebDNA app store (2011) Copyright ? (1997)