View Single Post
  #3  
Old July 6th 06, 06:26 PM posted to microsoft.public.outlook.program_forms
formfreak
external usenet poster
 
Posts: 1
Default date format on custom field

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.

Ads