A proper date conversion function?

[fernando.olmos at hpa.com.au]

Yes, that is slack of you Jeff... Shame, shame, shame! ;-)
Didn't you know that a Zero date is actually valid? Hehe
Seriously, I know what you mean.
Unfortunately we could be given a zero date from the client, which is
valid in our system. Of course if the field has anything other than a
space and it's still converting it to zero, then that's treating it as
invalid. Unfortunately (again), the ncon() function gives "data
conversion error", and we're also trying to avoid that due to "error
spybots" in the system reporting on exactly that error!
No, we need a proper date validation routine and I think Murray's
suggestion is the best so far.

cheers

----------------------------------------------------------------------

Message: 1
Date: Sat, 22 Sep 2007 01:48:28 +1000
From: Jeff Hoffman <wonicon at optusnet.com.au>
Subject: RE: A proper date conversion function?
To: powerh-l at lists.sowder.com
Message-ID: <200709211548.l8LFmlLt018344 at mail15.syd.optusnet.com.au>
Content-Type: text/plain; charset="iso-8859-1"; format=flowed

Hi

I know this might sound slack and it might not 
work in QTP, but could you not just set the field 
to a date field, if the result is 0 then the date was invalid?

Jeff
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed.  If
you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************