Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP General (http://www.velocityreviews.com/forums/f65-asp-general.html)
-   -   Dates! Dates! Dates! (http://www.velocityreviews.com/forums/t795763-dates-dates-dates.html)

PW 08-07-2004 12:27 AM

Dates! Dates! Dates!
 

<rant>

Sorry guys, but I just have to whinge. Dates in ASP are a total pain in the
butt! I seem to get caught out so many times. I realise its my own fault,
but going from the posts in this newsgroup and others, I'm not the only one.
Its just a poorly addressed issue within ASP. So for all your poor buggers
out there that are having problems, particularly with european date formats,
here is my solution.

I have the user enter their date in european format ("31-12-2004") and then
handle it this way ...

myDate = Request.QueryString("txtDate")
myArray = Split(myDate, "-")
myDD = myArray(0)
myMM = myArray(1)
myYYYY = myArray(2)
myISOdate = myYYYY & "-" & myMM & "-" & myDD

I find that ISO formatted dates typically go into the database of choice
pretty readily.

Hope this helps someone.

Cheers,
PW

</rant>



Evertjan. 08-07-2004 07:53 AM

Re: Dates! Dates! Dates!
 
PW wrote on 07 aug 2004 in microsoft.public.inetserver.asp.general:
> I have the user enter their date in european format ("31-12-2004") and
> then handle it this way ...
>
> myDate = Request.QueryString("txtDate")
> myArray = Split(myDate, "-")
> myDD = myArray(0)
> myMM = myArray(1)
> myYYYY = myArray(2)
> myISOdate = myYYYY & "-" & myMM & "-" & myDD


Usually I also allow for YY, the . and the /, so:

function myISOdate(d)
d = trim(d)
d = replace(d,".","-")
d = replace(d,"/","-")
a = Split(d,"-")
if len(a(2))=2 then a(2) = "20" & a(2)
myISOdate = a(2) & "-" & a(1) & "-" & a(0)
end function

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

PW 08-08-2004 02:07 PM

Re: Dates! Dates! Dates!
 

"Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message
news:Xns953E64970D1A0eejj99@194.109.133.29...
>
> Usually I also allow for YY, the . and the /, so:
>
> function myISOdate(d)
> d = trim(d)
> d = replace(d,".","-")
> d = replace(d,"/","-")
> a = Split(d,"-")
> if len(a(2))=2 then a(2) = "20" & a(2)
> myISOdate = a(2) & "-" & a(1) & "-" & a(0)
> end function



Hmmm, thats a good idea, except for if the user enters something like
"20/01/60" in which 60 become 2060 insted of 1960.
But I will incorporate that change, thanks. :-)




Evertjan. 08-08-2004 03:06 PM

Re: Dates! Dates! Dates!
 
PW wrote on 08 aug 2004 in microsoft.public.inetserver.asp.general:
>> if len(a(2))=2 then a(2) = "20" & a(2)

>
> Hmmm, thats a good idea, except for if the user enters something like
> "20/01/60" in which 60 become 2060 insted of 1960.


if you want to define that for say 2009/1910:

if len(a(2))=2 and +a(2)<10 then
a(2) = "20" & a(2)
elseif len(a(2))=2 and +a(2)>=10 then
a(2) = "19" & a(2)
end if


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Mark Schupp 08-09-2004 04:42 PM

Re: Dates! Dates! Dates!
 
It's really not an "ASP" problem. The same issues come up in any programming
environment where the person entering the dates may use a different format
than the system storing the dates. We finally gave up on manually entered
text dates in our system and now use a popup date calendar that always sends
the dates to the web server as "yyyymmdd hh:mm:ss",

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com


"PW" <pwa@NObigSPAMpond.net.au> wrote in message
news:eIM2XVBfEHA.384@TK2MSFTNGP10.phx.gbl...
>
> <rant>
>
> Sorry guys, but I just have to whinge. Dates in ASP are a total pain in

the
> butt! I seem to get caught out so many times. I realise its my own

fault,
> but going from the posts in this newsgroup and others, I'm not the only

one.
> Its just a poorly addressed issue within ASP. So for all your poor

buggers
> out there that are having problems, particularly with european date

formats,
> here is my solution.
>
> I have the user enter their date in european format ("31-12-2004") and

then
> handle it this way ...
>
> myDate = Request.QueryString("txtDate")
> myArray = Split(myDate, "-")
> myDD = myArray(0)
> myMM = myArray(1)
> myYYYY = myArray(2)
> myISOdate = myYYYY & "-" & myMM & "-" & myDD
>
> I find that ISO formatted dates typically go into the database of choice
> pretty readily.
>
> Hope this helps someone.
>
> Cheers,
> PW
>
> </rant>
>
>





All times are GMT. The time now is 03:57 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.