| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Format empty date cells | Excel Discussion (Misc queries) | |||
| Insert Current Date when cell is empty?? | Excel Worksheet Functions | |||
| Empty Date Cell as Zero | Excel Discussion (Misc queries) | |||
| Can a function returning a date return an empty value? | Excel Programming | |||
| Can blank cells created using empty Double-Quotes not be empty?? | Excel Programming | |||
Linear Mode
