Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   date field behaviour (http://www.outlookbanter.com/outlook-using-forms/10590-date-field-behaviour.html)

Long Nguyen April 5th 06 01:53 AM

date field behaviour
 
(outlook 2002, sp1)

In my custom form I created a date field with format hh:mm PM (that is
displaying only the time, not the date). When I entered 1700 (without . or
:) it displayed 8:00AM (instead of 5:00PM). Is this a bug or the way it
works?

(If I had . or :, e.g. 17:00 it converted to correct time of 5:00PM)

I did more investigation I found out that when 1700 was entered the field
had the year set to 1700 and time to 8:00AM. It seems that without the . or
: Outlook considered the value as the year. It seems that this is the way it
works.

Thks
Long



Long Nguyen April 5th 06 02:45 AM

date field behaviour
 
More on this - The start and end time fields in the Appoitment form seems to
work ok, ie. Outlook would convert a "1700" input to 5:00PM. I just wonder
how it is implemented. Any extra programming underneath is needed for this?



Sue Mosher [MVP-Outlook] April 6th 06 11:22 PM

date field behaviour
 
The date/time fields are all supposed to work with the same date logic, but your testing seems to indicate that is not in fact the case. I can't explain the discrepancy and can only suggest that you tell users to use 17:00, not 1700 unless they want to go back in time.

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

"Long Nguyen" wrote in message ...
More on this - The start and end time fields in the Appoitment form seems to
work ok, ie. Outlook would convert a "1700" input to 5:00PM. I just wonder
how it is implemented. Any extra programming underneath is needed for this?

(outlook 2002, sp1)

In my custom form I created a date field with format hh:mm PM (that is
displaying only the time, not the date). When I entered 1700 (without .. or
:) it displayed 8:00AM (instead of 5:00PM). Is this a bug or the way it
works?

(If I had . or :, e.g. 17:00 it converted to correct time of 5:00PM)

I did more investigation I found out that when 1700 was entered the field
had the year set to 1700 and time to 8:00AM. It seems that without the .. or
: Outlook considered the value as the year. It seems that this is the way it
works.


Long Nguyen April 13th 06 02:37 AM

date field behaviour
 
Thanks Sue.

Regards
Long
"Sue Mosher [MVP-Outlook]" wrote in message
...
The date/time fields are all supposed to work with the same date logic, but
your testing seems to indicate that is not in fact the case. I can't explain
the discrepancy and can only suggest that you tell users to use 17:00, not
1700 unless they want to go back in time.

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

"Long Nguyen" wrote in message
...
More on this - The start and end time fields in the Appoitment form seems
to
work ok, ie. Outlook would convert a "1700" input to 5:00PM. I just wonder
how it is implemented. Any extra programming underneath is needed for
this?

(outlook 2002, sp1)

In my custom form I created a date field with format hh:mm PM (that is
displaying only the time, not the date). When I entered 1700 (without . or
:) it displayed 8:00AM (instead of 5:00PM). Is this a bug or the way it
works?

(If I had . or :, e.g. 17:00 it converted to correct time of 5:00PM)

I did more investigation I found out that when 1700 was entered the field
had the year set to 1700 and time to 8:00AM. It seems that without the .
or
: Outlook considered the value as the year. It seems that this is the way
it
works.





All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com