Re: [WebDNA] MAX Date

This WebDNA talk-list message is from

2018


It keeps the original formatting.
numero = 114354
interpreted = N
texte = 1971 Hi Jess, If you want to retrieve the largest date use this WebDNA code instead: [search db=3Dpetsa.db&nePetsadatarq=3D[blank]&dePetsaSort=3D1&PetsaType=3DDate] [founditems] [showif [index]=3D1] [text]largestDate=3D[petsa][/text] [/showif] [index] - [math date]{[petsa]}[/math]
[/founditems] [/search] The largest date is [largestDate]. BTW, if you still have problems you might try formatting all those Petsa values in the db to WebDNA's standard date format which is MM/DD/YYYY. I'm pretty sure WebDNA does not actually require the preceding zeros in your single-digit month and day values, but it never hurts to comply with standards "just in case". :) Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 07/22/2018 09:06 AM, Jess Villamor wrote: > =3D=3D=3D=3D=3D=3Dpetsa.db=3D=3D=3D=3D=3D=3D=3D=3D=3D > ref=C2=A0=C2=A0=C2=A0 petsa > 1=C2=A0=C2=A0=C2=A0 1/2/2018 > 2=C2=A0=C2=A0=C2=A0 12/13/2016 > 3=C2=A0=C2=A0=C2=A0 7/20/2015 > 4=C2=A0=C2=A0=C2=A0 12/23/2018 > 5=C2=A0=C2=A0=C2=A0 4/5/2017 >=20 > Why can't I get the maximum date from the above database? >=20 > [search db=3Dpetsa.db&neRefData=3D0&PetsaSort=3D1&PetsaType=3DDate] > [max field=3Dpetsa] >

> [founditems] > [index] - [math date]{[petsa]}[/math]
> [/founditems] > [/search] >=20 > Thanks... > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list talk@webdna.us To unsubscribe, E-mail to: > talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: > support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] MAX Date (Kenneth Grome 2018)
  2. [WebDNA] MAX Date (Jess Villamor 2018)
1971 Hi Jess, If you want to retrieve the largest date use this WebDNA code instead: [search db=3Dpetsa.db&nePetsadatarq=3D[blank]&dePetsaSort=3D1&PetsaType=3DDate] [founditems] [showif [index]=3D1] [text]largestDate=3D[petsa][/text] [/showif] [index] - [math date]{[petsa]}[/math]
[/founditems] [/search] The largest date is [largestDate]. BTW, if you still have problems you might try formatting all those Petsa values in the db to WebDNA's standard date format which is MM/DD/YYYY. I'm pretty sure WebDNA does not actually require the preceding zeros in your single-digit month and day values, but it never hurts to comply with standards "just in case". :) Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 07/22/2018 09:06 AM, Jess Villamor wrote: > =3D=3D=3D=3D=3D=3Dpetsa.db=3D=3D=3D=3D=3D=3D=3D=3D=3D > ref=C2=A0=C2=A0=C2=A0 petsa > 1=C2=A0=C2=A0=C2=A0 1/2/2018 > 2=C2=A0=C2=A0=C2=A0 12/13/2016 > 3=C2=A0=C2=A0=C2=A0 7/20/2015 > 4=C2=A0=C2=A0=C2=A0 12/23/2018 > 5=C2=A0=C2=A0=C2=A0 4/5/2017 >=20 > Why can't I get the maximum date from the above database? >=20 > [search db=3Dpetsa.db&neRefData=3D0&PetsaSort=3D1&PetsaType=3DDate] > [max field=3Dpetsa] >

> [founditems] > [index] - [math date]{[petsa]}[/math]
> [/founditems] > [/search] >=20 > Thanks... > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list talk@webdna.us To unsubscribe, E-mail to: > talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: > support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us . Kenneth Grome

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:

Limit to Field Length in DB (1998) Multiple fields on 1 input (1997) emailer error -108 (1997) Thanks Grant (1997) Why does 0 divided by 1=1? (2003) For you Unix gurus [OT] (2002) Date search - yes or no (1997) Duplicate Hell (1999) Announcement-WebCatalog 2.0 Released (1997) Summing fields (1997) I give up!! (1997) OT: Poll Please (2002) Linux -> OS X (2002) Price Not Appearing (2000) Banner DNA (1997) Error with [applescript] (1999) Frames (1997) upgrade? (1997) PageMaker/Quark to db (1999) One more time (1997)