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:

Re: [WebDNA] MAX Date (Kenneth Grome 2018)
[WebDNA] MAX Date (Jess Villamor 2018)

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]>

DOWNLOAD WEBDNA NOW!

Re: [WebDNA] MAX Date

2018

Top Articles:

Related Readings: