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

Date Diff help

P: n/a
I have a report in Access. I want to calculate with the DateDiff
function. Two questions.

1. How do I set up the Date Diff to subtract a date in the past from
today's date? I want this to be dynamic, automatically incrementing
the day count based on the current day's date. (I do not input the
current day's date into any field, so it will need to come from the
system clock???)

2. How do I implement this into my report? I have a column that shows
the day I received the item. (This is the field being subtracted from
the current day's date.) Next to this column, I want to place a Day
Count column that will display the weekday difference between the day
the unit was received and the current day's date.

Thanks for your help in advance.

Troy Lee

Dec 13 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Dec 13, 11:05 am, Troy Lee <troy.le...@gmail.comwrote:
I have a report in Access. I want to calculate with the DateDiff
function. Two questions.

1. How do I set up the Date Diff to subtract a date in the past from
today's date? I want this to be dynamic, automatically incrementing
the day count based on the current day's date. (I do not input the
current day's date into any field, so it will need to come from the
system clock???)

2. How do I implement this into my report? I have a column that shows
the day I received the item. (This is the field being subtracted from
the current day's date.) Next to this column, I want to place a Day
Count column that will display the weekday difference between the day
the unit was received and the current day's date.

Thanks for your help in advance.

Troy Lee

datediff("d"[yourdatefieldname],date())

Ron
Dec 13 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.