ms outlook 2003 sp2

Hi I would like to resolve an issue with the way a date is appearing in my
custom outlook form.

1. I imported about 800 records with a membership start date, and creted a
field that calculates renewal date with this value dateadd ("m", 12, [User
Field 1])

calculations work ok on about half the dates but on the other half it seems
to transpose the order from mm/dd/yyy to dd/mm/yyy.

2. If I Copy these records from the phone list and paste them in an excell
file, and format cells to show dates yyyy/mm/dd half the records dont convert
to that format and remain in mm/dd/yyyy.

I want the custom contact form to display dates as yyyy/mm/dd and cant find
a solution on this forum.

I also would like to know if there is a way to check all the dates in the
database so they all behave the same way.

ok after some extensive searching, and a lot of experimentation I got this
code to work

Format(DateAdd("m", 12, [User Field 1]), "yyyy/MM/dd")



"artmyth" wrote:

ms outlook 2003 sp2

Hi I would like to resolve an issue with the way a date is appearing in my
custom outlook form.

1. I imported about 800 records with a membership start date, and creted a
field that calculates renewal date with this value dateadd ("m", 12, [User
Field 1])

calculations work ok on about half the dates but on the other half it seems
to transpose the order from mm/dd/yyy to dd/mm/yyy.

2. If I Copy these records from the phone list and paste them in an excell
file, and format cells to show dates yyyy/mm/dd half the records dont convert
to that format and remain in mm/dd/yyyy.

I want the custom contact form to display dates as yyyy/mm/dd and cant find
a solution on this forum.

I also would like to know if there is a way to check all the dates in the
database so they all behave the same way.

I have a related question...

I am trying to calculate the number of days and hours between when a form is
sent to an employee and when they reply via the email form. Is there any way
to create a field that update automatically when a form is initally populated
and sent, without having this date and time overriden in the form when it
comes back from the second user? Essentially I am trying to find a way to
automate a Turn around Time metric.

"artmyth" wrote:

ok after some extensive searching, and a lot of experimentation I got this
code to work

Format(DateAdd("m", 12, [User Field 1]), "yyyy/MM/dd")



"artmyth" wrote:

ms outlook 2003 sp2

Hi I would like to resolve an issue with the way a date is appearing in my
custom outlook form.

1. I imported about 800 records with a membership start date, and creted a
field that calculates renewal date with this value dateadd ("m", 12, [User
Field 1])

calculations work ok on about half the dates but on the other half it seems
to transpose the order from mm/dd/yyy to dd/mm/yyy.

2. If I Copy these records from the phone list and paste them in an excell
file, and format cells to show dates yyyy/mm/dd half the records dont convert
to that format and remain in mm/dd/yyyy.

I want the custom contact form to display dates as yyyy/mm/dd and cant find
a solution on this forum.

I also would like to know if there is a way to check all the dates in the
database so they all behave the same way.

Use a different reply form that calculates its own "reply time" custom field with an initial value setting.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"formfreak" wrote in message ...
I have a related question...

I am trying to calculate the number of days and hours between when a form is
sent to an employee and when they reply via the email form. Is there any way
to create a field that update automatically when a form is initally populated
and sent, without having this date and time overriden in the form when it
comes back from the second user? Essentially I am trying to find a way to
automate a Turn around Time metric.

"artmyth" wrote:

ok after some extensive searching, and a lot of experimentation I got this
code to work

Format(DateAdd("m", 12, [User Field 1]), "yyyy/MM/dd")



"artmyth" wrote:

ms outlook 2003 sp2

Hi I would like to resolve an issue with the way a date is appearing in my
custom outlook form.

1. I imported about 800 records with a membership start date, and creted a
field that calculates renewal date with this value dateadd ("m", 12, [User
Field 1])

calculations work ok on about half the dates but on the other half it seems
to transpose the order from mm/dd/yyy to dd/mm/yyy.

2. If I Copy these records from the phone list and paste them in an excell
file, and format cells to show dates yyyy/mm/dd half the records dont convert
to that format and remain in mm/dd/yyyy.

I want the custom contact form to display dates as yyyy/mm/dd and cant find
a solution on this forum.

I also would like to know if there is a way to check all the dates in the
database so they all behave the same way.