Answered by:
Test for Null date value in VBA

Question
-
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
-
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
-
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 -
Jan, thank you :)
Ben Howard [MVP] http://appleparkltd.spaces.live.com/Wednesday, July 28, 2010 4:07 PM -
Actually VBA has an even simpler test:If ActiveProject.Tasks(1).ActualStart = "NA" Thenworks fine.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 ManagementThursday, July 29, 2010 9:23 AM -
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