Labels

Biography      Videos>     Cricket
Google

Wednesday, November 4, 2009

Problem in IsDate Function

There is a problem while using the IsDate Function. When we give invalid date like
"197703/02", Instead of returning false, the IsDate function returns true and consider it as a valid date. The work around for the problem is given below, A Custom IsDate function that validates the date and returns whether it is a valid or invalid.

Function MyIsDate(MyText)
If IsDate(MyText) Then
If 1 > Left(MyText, 2) > 12 Or Len(MyText) <> 8 Then
MyIsDate = False
Else
MyIsDate = True
End If
Else
MyIsDate = False
End If
End Function

6 comments:

Anonymous said...

hi, jenkins-thoughts.blogspot.com!
[url=http://cialisdec.fora.pl/] cialis bestellen online[/url] [url=http://cialisded.fora.pl/] cialis [/url] [url=http://cialisdee.fora.pl/] cialis online[/url] [url=http://cialisdef.fora.pl/] cialis kaufen [/url] [url=http://cialisdeg.fora.pl/] cialis online[/url] [url=http://cialisdeh.fora.pl/] cialis [/url]

Anonymous said...

Hello !.
You may , probably curious to know how one can make real money .
There is no initial capital needed You may commense earning with as small sum of money as 20-100 dollars.

AimTrust is what you need
The firm incorporates an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

Its head office is in Panama with structures everywhere: In USA, Canada, Cyprus.
Do you want to become really rich in short time?
That`s your choice That`s what you wish in the long run!

I`m happy and lucky, I began to take up income with the help of this company,
and I invite you to do the same. It`s all about how to choose a correct companion utilizes your funds in a right way - that`s AimTrust!.
I earn US$2,000 per day, and what I started with was a funny sum of 500 bucks!
It`s easy to start , just click this link http://jisekihi.angelcities.com/xotema.html
and go! Let`s take this option together to feel the smell of real money

Anonymous said...

Good day, sun shines!
There have were times of troubles when I felt unhappy missing knowledge about opportunities of getting high yields on investments. I was a dump and downright stupid person.
I have never thought that there weren't any need in large starting capital.
Now, I feel good, I started to get real money.
It gets down to select a correct partner who uses your money in a right way - that is incorporate it in real business, parts and divides the income with me.

You may ask, if there are such firms? I have to answer the truth, YES, there are. Please be informed of one of them:
http://theblogmoney.com

Anonymous said...

Good day!

Let me introduce myself,
friends call me James F. Collins.
Generally I’m a venturesome gambler. recently I take a great interest in online-casino and poker.
Not long time ago I started my own blog, where I describe my virtual adventures.
Probably, it will be interesting for you to utilize special software facilitating winnings .
Please visit my web site. http://allbestcasino.com I’ll be glad would you find time to leave your opinion.

Amit said...

Great post.Love to read more.every student must read this blog.
mba

Amit said...

Great post.Love to read more.every student must read this blog.
mba