Dateadd problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I've got a problem with my form auto complete textbox. I've got a textbox
named "FinishDate" and On the load of my form I want to put the initial value
of this field with date of today + 14 days.
I try it with DateAdd function but I'm not sure it is working well or I
think I don't write the good parameters on it.
Thanks for your help!
 
DateAdd("d", 14, Date)
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
What is the meaning of the "d" the 14 and the date
because I try dateadd("d",14,date) and dateadd("d",14,TODAY) and my fiel on
startup is "Néant".
 
"d" is the unit of time measurement being added.

Date() is a function that returns today's date.

You can learn all about the DateAdd or Date function by typing it into any VBA window, selecting that text and pressing F1.

Is your textbox bound to an Outlook date/time property?
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


Josianne said:
What is the meaning of the "d" the 14 and the date
because I try dateadd("d",14,date) and dateadd("d",14,TODAY) and my fiel on
startup is "Néant".
Click to expand...
 
Thanks a lot, I've found dateadd("d",14,NOW).
I try it before with TODAY or DATE and it don't work because I've got a
french version of outlook on this computer.
Thanks again problem resolve!
 
Back
Top