Dateadd problem

[Josianne]

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!

 

[Sue Mosher [MVP-Outlook]]

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

 

[Josianne]

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".

 

[Sue Mosher [MVP-Outlook]]

"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

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".

 

[Josianne]

Is your textbox bound to an Outlook date/time property?
Yes, I already do it

 

[Josianne]

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!