This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Test for Null date value in VBA

Question
0

Sign in to vote

Hello gurus, I'd like to test for a null date value in vba, along the lines of

if tsk.actualstart = NULL then....

Any ideas?
Ben Howard [MVP] http://appleparkltd.spaces.live.com/

Wednesday, July 28, 2010 3:26 PM

Answers

1

Sign in to vote
Hi Ben,

Just wrote it a few minutes ago:

if not isdate(tsk.actualstart) then

Greetings,
- Marked as answer by Ben Howard [MVP]MVP Wednesday, July 28, 2010 4:07 PM
Wednesday, July 28, 2010 3:51 PM

All replies

1

Sign in to vote
Hi Ben,

Just wrote it a few minutes ago:

if not isdate(tsk.actualstart) then

Greetings,
- Marked as answer by Ben Howard [MVP]MVP Wednesday, July 28, 2010 4:07 PM
Wednesday, July 28, 2010 3:51 PM
0

Sign in to vote

Jan, thank you :)
Ben Howard [MVP] http://appleparkltd.spaces.live.com/

Wednesday, July 28, 2010 4:07 PM
0

Sign in to vote

Actually VBA has an even simpler test:

If ActiveProject.Tasks(1).ActualStart = "NA" Then

works fine.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

"Ben_Howard" wrote in message news:fca1236a-8ec2-4c19-aabc-18c2f358ffbf...
Jan, thank you :)
Ben Howard [MVP] http://appleparkltd.spaces.live.com/

__________ Information from ESET Smart Security, version of virus signature database 5322 (20100729) __________

The message was checked by ESET Smart Security.

http://www.eset.com
The one and only Project VBA Book Rod Gill Project Management

Thursday, July 29, 2010 9:23 AM
1

Sign in to vote

Hi Rod,

Simpler maybe, but NOT language-independent which in my part of the world is very important.

That is why I never use it.

Thursday, July 29, 2010 11:10 AM