PC Review


Reply
Thread Tools Rate Thread

date/time field, current year

 
 
Mary
Guest
Posts: n/a
 
      29th Apr 2009
I have a user-defined date/time field on a form that has the initial value
set to Date(). I want the user to be able to edit the date as needed, but
quite often it will be the current date. In other office programs, you can
enter a date such as 4/29 and it will autofill with 4/29/09 adding the
current year. In my case it comes out 4/29/10. Is this normal behavior and
is there a way around it? I'm fairly new to Outlook forms.

Thanks,
Mary
 
Reply With Quote
 
 
 
 
Mary
Guest
Posts: n/a
 
      29th Apr 2009
I just noticed that only happens if the date is earlier than April 1st...

"Mary" wrote:

> I have a user-defined date/time field on a form that has the initial value
> set to Date(). I want the user to be able to edit the date as needed, but
> quite often it will be the current date. In other office programs, you can
> enter a date such as 4/29 and it will autofill with 4/29/09 adding the
> current year. In my case it comes out 4/29/10. Is this normal behavior and
> is there a way around it? I'm fairly new to Outlook forms.
>
> Thanks,
> Mary

 
Reply With Quote
 
Sue Mosher [MVP]
Guest
Posts: n/a
 
      29th Apr 2009
Yes, that's normal behavior -- if the year is not specified, Outlook adds
the most likely year. I'm not sure what kind of workaround you're looking
for, unless you can read the user's mind about what date they're likely to
really want.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Mary" <(E-Mail Removed)> wrote in message
news:C1325E92-E513-4843-9E8F-(E-Mail Removed)...
>I just noticed that only happens if the date is earlier than April 1st...
>
> "Mary" wrote:
>
>> I have a user-defined date/time field on a form that has the initial
>> value
>> set to Date(). I want the user to be able to edit the date as needed,
>> but
>> quite often it will be the current date. In other office programs, you
>> can
>> enter a date such as 4/29 and it will autofill with 4/29/09 adding the
>> current year. In my case it comes out 4/29/10. Is this normal behavior
>> and
>> is there a way around it? I'm fairly new to Outlook forms.
>>
>> Thanks,
>> Mary



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bound Date/Time field to automatically display the current date Billiam Microsoft Access Database Table Design 2 20th Sep 2009 11:13 PM
Paste current date and time into field Fester Microsoft Access 5 4th Jun 2009 05:18 PM
Updating year only portion of date/time field Greg Microsoft Access Queries 3 26th Aug 2004 07:06 PM
Re: Inserting Current Time and Date into field Bat Microsoft Access 0 20th Jan 2004 08:14 PM
Inserting Current Time and Date into field Les Microsoft Access 0 20th Jan 2004 05:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:45 AM.