Thread: how to check that a var type date is initialized ??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
François François is offline
external usenet poster
  
Posts: 40
Default how to check that a var type date is initialized ??
Let's suppose a declaration like this

1. Set the static value

Call LastInputDate(#08/15/2005#)

2. Display the static value
MsgBox(LastInputDate)

Function LastInputDate (Optional dDate as date) as date
Static dLastDate as Date

If IsEmpty(dDate) then
LastInputDate = dLAstDate
Else
dLastDate = dDate
End Function.


This is never working since dDate contains allways "12:00:00 Am". How to
solve this ?
Reply With QuoteReply With Quote