Date Field in Task Form

[Joel]

Hello,

By default, a date field is "None" until you type in a
date like 3/25/04.

In my script, I've tried these if statements and they do
not work:

If prps("DateField1") = "None" Then
If prps("DateField1") = "" Then
If prps("DateField1").value = "" Then
If prps("DateField1").value = "None" Then


Is this a valid if statement? Could it be that None is
not the default value? Please help.

Thanks - Joel

 

[Sue Mosher [MVP-Outlook]]

The date that Outlook is actually storing when you see "None" is #1/1/4501#.
Therefore, try:

If prps("DateField1") = #1/1/4501# Then

 

[Joel]

Wow, thanks! How could I have figured that one out
without your help? Why is it like that?

-Joel

 

[Sue Mosher [MVP-Outlook]]

One way to figure out all kinds of internals like this is to use a tool like
the Mdbvu32.exe from Microsoft or Outlook Spy from http://www.dimastr.com

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers