Re: check if an item is a date

2005-03-18 Thread Rob Cozens
Xavier, I accidentally deleted your message before going throught it in depth; so I'm working from memory. What is the source of the large numbr of dates you are processing/validating? If the source is automated, why aren't the dates validated at input? Are you really needing to make sure the

Re: check if an item is a date

2005-03-18 Thread Mark Wieder
Alex- Thursday, March 17, 2005, 4:31:29 PM, you wrote: >> /Break out your party hats. According to = >> http://www.onlineconversion.com/unix_time.htm , Unix time is supposed = >> reach 11 on Fri, 18 Mar 2005 01:58:31 GMT That's only = >> 1036372537 seconds from 2^31 (ie Tue, 19 Jan 203

Re: check if an item is a date

2005-03-17 Thread Alex Tweedly
Since we're talking about dates, and date formats, I thought I'd forward a note from /. /Break out your party hats. According to http://www.onlineconversion.com/unix_time.htm , Unix time is supposed reach 11 on Fri, 18 Mar 2005 01:58:31 GMT That's only 1036372537 seconds from 2^31 (ie

RE: check if an item is a date

2005-03-17 Thread MisterX
eit(isdate($mydata))) into isvalidformateddata ;) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Frank D. Engel, Jr. > Sent: Thursday, March 17, 2005 18:16 > To: How to use Revolution > Subject: Re: check if an item is a date &g

RE: check if an item is a date

2005-03-17 Thread MisterX
better for all... Sorry if I sounded angry before... Xav -- http://MonsieurX.com/runrev.php Nitrous IDE tools - brakepads not necessary! > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Rob Cozens > Sent: Thursday, March 17, 2

Re: check if an item is a date

2005-03-17 Thread Rob Cozens
Frank, et al, note that I seem to have come across a problem with this that sticks a leading zero on the day number, even though my system prefs do not call for one. I see that in Transcript also; it was not a problem in HyperTalk. BTW, doesn't your long date conversion test fail for dates outsid

Re: check if an item is a date

2005-03-17 Thread Frank D. Engel, Jr.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Want to be even more flexible? Try this: convert myvalue to long date if it is "invalid date" then answer "That date is invalid!" else put it into myvalue end if This will convert other recognized date formats into the long date format and replace

Re: check if an item is a date

2005-03-17 Thread Rob Cozens
Jacque, et al, I see seconds & fixed notations (yours + Julian + whatever) as non-sequitur: To put it another way: For user input validation, a date is valid ONLY if it conforms to the computer's current system date format. Rob Cozens, Staff Conservator Mendonoma Marine Life Conservancy "Fisherme

Re: check if an item is a date

2005-03-17 Thread Rob Cozens
Jacque, et al, If you can think of a bullet-proof way to evaluate dates in all languages, with all types of delimiters, with all types of system date formats, without mistaking seconds or fixed-length notations as non-dates, you might consider submitting a feature request with your suggestions.

Re: check if an item is a date

2005-03-17 Thread J. Landman Gay
On 3/17/05 6:38 AM, [EMAIL PROTECTED] wrote: No matter that I get weird data gathering item 3 of it... yet ANOTHER bug! But surprise! put (2485694 is a date) I don't think this is a bug. Evaluating dates is a tricky business and I think the engine does a pretty good job of it. We can't expect it

Re: check if an item is a date

2005-03-17 Thread Rob Cozens
This is nothing new, Xavier, But surprise! put (2485694 is a date) It gets worse... 1 is also a date! So either the << is a date>> function is useless as a date checker and we all must roll our own AGAIN Virtually any integer represents a date in seconds format in xTalks; so if you need need to va

RE: check if an item is a date

2005-03-17 Thread MisterX
Xavier > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, March 17, 2005 13:39 > To: use-revolution@lists.runrev.com > Subject: check if an item is a date > > Hi everyone, > > Alt

check if an item is a date

2005-03-17 Thread xbury . cs
Hi everyone, Although I discovered this bug using MetaCard, it wasn't surprising that it didn't work either in Rev... After the date sorting and conversion problems, this comes as the cherry on the cake... I got this nice table "title" field which automatically sorts the columns below. I've