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

Future date displayed in a table

P: n/a
I wish to show a future date in a table, so that I can sort and know
which case is in need of a review. I can display a future date in a
form but I want to see all records that are due on a certain date.
Any help would be appreciated.
Regards
G.K.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

asreryll wrote:
I wish to show a future date in a table, so that I can sort and know
which case is in need of a review. I can display a future date in a
form but I want to see all records that are due on a certain date.
Any help would be appreciated.
Regards
G.K.


Have a look at the DateAdd function in the help files.

Nov 13 '05 #2

P: n/a
On 1 Apr 2005 04:43:34 -0800, asreryll wrote:
I wish to show a future date in a table, so that I can sort and know
which case is in need of a review. I can display a future date in a
form but I want to see all records that are due on a certain date.
Any help would be appreciated.
Regards
G.K.


No need to store that future date.
All you need store is the original date.

To see the review dates for all records 90 days after the original
date, in a query, add a new column.
ReviewDate:DateAdd("d",90,[OriginalDate])
Sort this field

To see those records due for review today you can add criteria to the
column:
= Date()

For those due for review tomorrow:
= Date() + 1

See VBA help for the additional arguments available for the DateAdd
function.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.