[cfaussie] Re: Validating dates ... what's the trick?

2009-02-19 Thread Mike Kear
AH! Ok i see what the difference is. You're giving it a string, not a date object. That's where I was falling over - i was trying ot give it a date object, and of course you can't create an invalid date object. So createdate was throwing an error before it even got to the validation function

[cfaussie] Re: Validating dates ... what's the trick?

2009-02-19 Thread Adam Chapman
onth this way.. Regards, Adam -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Friday, February 20, 2009 3:56 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Validating dates ... what's the trick? The problem is i'm building the date from 3 dropdo

[cfaussie] Re: Validating dates ... what's the trick?

2009-02-19 Thread Mike Kear
The problem is i'm building the date from 3 dropdowns for day, month and year, so the day dropdown has 1-31 on it. Therefore it's possible to select 31/Feb/2009. Then if you try to validate the date from the form, by feeding those three values into the LSIsDate() function, or the IsValid(Date

[cfaussie] Re: Validating dates ... what's the trick?

2009-02-19 Thread Chris Velevitch
Did you try the LSIsDate function? Chris -- Chris Velevitch Manager - Adobe Platform Users Group, Sydney m: 0415 469 095 www.apugs.org.au Adobe Platform Users Group, Sydney Feb '09 meeting: Hands On Cairngorm Basics Date: Mon 23rd Feb 6pm for 6:30 start Details and RSVP on http://groups.adobe.c

[cfaussie] Re: Validating dates ... what's the trick?

2009-02-19 Thread Mike Kear
method.. I do the same thang myself. > > Regards, > Adam > > > -Original Message- > From: Brett Payne-Rhodes [mailto:bret...@gmail.com] > Sent: Friday, February 20, 2009 3:17 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: Validating dates ... what'

[cfaussie] Re: Validating dates ... what's the trick?

2009-02-19 Thread Adam Chapman
I second Brett's method.. I do the same thang myself. Regards, Adam -Original Message- From: Brett Payne-Rhodes [mailto:bret...@gmail.com] Sent: Friday, February 20, 2009 3:17 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Validating dates ... what's the trick?

[cfaussie] Re: Validating dates ... what's the trick?

2009-02-19 Thread Brett Payne-Rhodes
I could never get a reliable result from the various 'parsedate' functions... In the end I wrote my own function to create dates from strings. It looks for a variety of delimiters then extracts day, month, year; or month, year, day; or even year, month, day; depending on how it was set up. The

[cfaussie] Re: Validating dates ... what's the trick?

2009-02-19 Thread Zac Spitzer
have you set the locale? I would be using the LS* functions for this stuff z On Fri, Feb 20, 2009 at 3:04 PM, Mike Kear wrote: > > I'm trying to catch when a user inputs an invalid date from a set of > dropdowns for day/month/year. What's the trick to using > IsValid("eurodate", ? Th