By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,171 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Date field

P: n/a
Hello, I need to add a date function in a field that returns a future
date.

What I need is to show a field with a date referred to the next two
years in mm/yyyy format.

Example: This month is 11/2003. I need to show in the text box:
11/2005.

THanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Place the following in the control source of the field to display the new
date.
=DateAdd("yyyy",2,[FieldNameWithSmallerDate])
In the field's format property type mm/yyyy. This will display the new date
how you want.

Stewart
"Paolo" <jp***@tin.it> wrote in message
news:9f**************************@posting.google.c om...
Hello, I need to add a date function in a field that returns a future
date.

What I need is to show a field with a date referred to the next two
years in mm/yyyy format.

Example: This month is 11/2003. I need to show in the text box:
11/2005.

THanks.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.