Date Field in Task Form

  • Thread starter Thread starter Joel
  • Start date Start date
J

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
 
The date that Outlook is actually storing when you see "None" is #1/1/4501#.
Therefore, try:

If prps("DateField1") = #1/1/4501# Then
 
Wow, thanks! How could I have figured that one out
without your help? Why is it like that?

-Joel
 
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
 
Back
Top