What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

[foundItems] context question --returns some fields but not others-- (2000) Resume Catalog ? (1997) Sum of Quantities (1997) Banners and sort of random display (1997) Orders coming up blank (2004) Can I invoke an ssi plugin from within a webcat page (1997) RE: EXTERNAL EMAIL: [WebDNA] find missing file in [listfiles] (2019) code to phantom spacing (2001) Some Questions (1997) Fun with dates (1997) DomainList (2005) WebDNA Solutions ... sorry! (1997) [OT] Xserve (2002) the dreaded unitShipCost (2003) Help formatting search results w/ table (1997) New WebCatalog Version !!! (1997) Question about [encrypt] (1998) Not really WebCat (1997) WC2f3 (1997) unable to launch acgi in WebCat (1997)