Empty Date
 

Hi all,

Just want to know if there are methods to assign an empty date (or null
value) to a date variable, just like I can assign and empty string "" to a
string variable. Thanks.

Frederick Chow
Hong Kong.

Empty Date
 

AFAIK, no. As with other numeric variables, date data types are given an
initial value of 0.

If you use a Variant instead, you can assign Null to it.

In article ,
"Frederick Chow" wrote:

Hi all,

Just want to know if there are methods to assign an empty date (or null
value) to a date variable, just like I can assign and empty string "" to a
string variable. Thanks.

Frederick Chow
Hong Kong.

Empty Date
 

Thanks a lot then.

"JE McGimpsey" wrote in message
...
AFAIK, no. As with other numeric variables, date data types are given an
initial value of 0.

If you use a Variant instead, you can assign Null to it.

In article ,
"Frederick Chow" wrote:

Hi all,

Just want to know if there are methods to assign an empty date (or null
value) to a date variable, just like I can assign and empty string "" to
a
string variable. Thanks.

Frederick Chow
Hong Kong.