Re: [WebDNA] MAX Date
This WebDNA talk-list message is from 2018
It keeps the original formatting.
numero = 114354
interpreted = N
texte = 1971Hi Jess,If you want to retrieve the largest date use this WebDNA code instead:[searchdb=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 thosePetsa values in the db to WebDNA's standard date format which isMM/DD/YYYY. I'm pretty sure WebDNA does not actually require thepreceding zeros in your single-digit month and day values, but itnever hurts to comply with standards "just in case".:)Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 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 tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
1971Hi Jess,If you want to retrieve the largest date use this WebDNA code instead:[searchdb=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 thosePetsa values in the db to WebDNA's standard date format which isMM/DD/YYYY. I'm pretty sure WebDNA does not actually require thepreceding zeros in your single-digit month and day values, but itnever hurts to comply with standards "just in case".:)Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 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 tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug 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)