Count days overdue formula help

Hello I have a text box "txtPeriodTo" that has a date in it. I want to add a
text box or label next to it that wiil count the days starting from the
txtPeriodTo to the current day and show it in my label or text box next to
it. I dont need to save this data. What would the formula be to acomplish
this? Thanks..
--
Newbies need extra loven.........

Look in Help for DateDiff().

HTH
--
-Larry-
--

"Chad" wrote in message
...
Hello I have a text box "txtPeriodTo" that has a date in it. I want
to add a
text box or label next to it that wiil count the days starting from
the
txtPeriodTo to the current day and show it in my label or text box
next to
it. I dont need to save this data. What would the formula be to
acomplish
this? Thanks..
--
Newbies need extra loven.........

I want to add a text box next to it and have it appear when its past the
date and count the days that has gone past. I put this code in the text box's
control source next to the one that shows the date but it shows a negative
number if before the date shown but works if it has gone past the date. What
do I need to add to the code to make this work to where it wont be visable
unless it goes past the date?

=Format(DateDiff("d",[txtPeriodEndDate],Date()),0) & " Days Past Due"
--
Newbies need extra loven.........


"Larry Daugherty" wrote:

Look in Help for DateDiff().

HTH
--
-Larry-
--

"Chad" wrote in message
...
Hello I have a text box "txtPeriodTo" that has a date in it. I want
to add a
text box or label next to it that wiil count the days starting from
the
txtPeriodTo to the current day and show it in my label or text box
next to
it. I dont need to save this data. What would the formula be to
acomplish
this? Thanks..
--
Newbies need extra loven.........

=IIf(DateDiff("d",[txtPeriodEndDate],Date()) 0,
Format(DateDiff("d",[txtPeriodEndDate],Date()),"0") & " Days Past Due",
Null)


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Chad" wrote in message
...
I want to add a text box next to it and have it appear when its past the
date and count the days that has gone past. I put this code in the text
box's
control source next to the one that shows the date but it shows a negative
number if before the date shown but works if it has gone past the date.
What
do I need to add to the code to make this work to where it wont be visable
unless it goes past the date?

=Format(DateDiff("d",[txtPeriodEndDate],Date()),0) & " Days Past Due"
--
Newbies need extra loven.........


"Larry Daugherty" wrote:

Look in Help for DateDiff().

HTH
--
-Larry-
--

"Chad" wrote in message
...
Hello I have a text box "txtPeriodTo" that has a date in it. I want
to add a
text box or label next to it that wiil count the days starting from
the
txtPeriodTo to the current day and show it in my label or text box
next to
it. I dont need to save this data. What would the formula be to
acomplish
this? Thanks..
--
Newbies need extra loven.........

Thanks douglas worked like a charm!
--
Newbies need extra loven.........


"Douglas J. Steele" wrote:

=IIf(DateDiff("d",[txtPeriodEndDate],Date()) 0,
Format(DateDiff("d",[txtPeriodEndDate],Date()),"0") & " Days Past Due",
Null)


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Chad" wrote in message
...
I want to add a text box next to it and have it appear when its past the
date and count the days that has gone past. I put this code in the text
box's
control source next to the one that shows the date but it shows a negative
number if before the date shown but works if it has gone past the date.
What
do I need to add to the code to make this work to where it wont be visable
unless it goes past the date?

=Format(DateDiff("d",[txtPeriodEndDate],Date()),0) & " Days Past Due"
--
Newbies need extra loven.........


"Larry Daugherty" wrote:

Look in Help for DateDiff().

HTH
--
-Larry-
--

"Chad" wrote in message
...
Hello I have a text box "txtPeriodTo" that has a date in it. I want
to add a
text box or label next to it that wiil count the days starting from
the
txtPeriodTo to the current day and show it in my label or text box
next to
it. I dont need to save this data. What would the formula be to
acomplish
this? Thanks..
--
Newbies need extra loven.........

Is there a way to only count working days using DateDiff



Cha wrote:

Thanks douglas worked like a charm!
16-Nov-07

Thanks douglas worked like a charm!
--
Newbies need extra loven.........


"Douglas J. Steele" wrote:

Previous Posts In This Thread:

On Friday, November 16, 2007 2:41 AM
Cha wrote:

Count days overdue formula help
Hello I have a text box "txtPeriodTo" that has a date in it. I want to add a
text box or label next to it that wiil count the days starting from the
txtPeriodTo to the current day and show it in my la

On Friday, November 16, 2007 5:01 AM
Larry Daugherty wrote:

Count days overdue formula help
Look in Help for DateDiff().

HTH
--
-Larry-
--

to add a
the
next to
acomplish

On Friday, November 16, 2007 5:27 AM
Cha wrote:

I want to add a text box next to it and have it appear when its past the date
I want to add a text box next to it and have it appear when its past the
date and count the days that has gone past. I put this code in the text box's
control source next to the one that shows the dat

On Friday, November 16, 2007 7:01 AM
Douglas J. Steele wrote:

=IIf(DateDiff("d",[txtPeriodEndDate],Date()) 0,
=IIf(DateDiff("d",[txtPeriodEndDate],Date()) 0,
Format(DateDiff("d",[txtPeriodEndDate],Date()),"0") & " Days Past Due",
Null)


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mail

On Friday, November 16, 2007 7:56 AM
Cha wrote:

Thanks douglas worked like a charm!
Thanks douglas worked like a charm!
--
Newbies need extra loven.........


"Douglas J. Steele" wrote:

EggHeadCafe - Software Developer Portal of Choice
SQL Server 2005 Paging Performance Tip
http://www.eggheadcafe.com/tutorials...paging-pe.aspx

On Tue, 20 Oct 2009 10:20:07 -0700, michael dean wrote:

Is there a way to only count working days using DateDiff

Not directly, because when Microsoft programmed the code for DateDiff, they
did not know which days *you* consider "working days". Those might be
different for different companies!

You can come up with a customized version for your particular needs, though.
See the sample code at
http://www.mvps.org/access/datetime/date0012.htm

You may also want to do a Bing or Google search for "workday math" - it's a
very common problem with many published solutions.
--

John W. Vinson [MVP]

You might try this one:

http://www.mvps.org/access/datetime/date0006.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


michael dean wrote in message
news:2009102013206michaeldean@libertyassetrecovery .com...
Is there a way to only count working days using DateDiff



Cha wrote:

Thanks douglas worked like a charm!
16-Nov-07

Thanks douglas worked like a charm!
--
Newbies need extra loven.........


"Douglas J. Steele" wrote:

Previous Posts In This Thread:

On Friday, November 16, 2007 2:41 AM
Cha wrote:

Count days overdue formula help
Hello I have a text box "txtPeriodTo" that has a date in it. I want to add
a
text box or label next to it that wiil count the days starting from the
txtPeriodTo to the current day and show it in my la

On Friday, November 16, 2007 5:01 AM
Larry Daugherty wrote:

Count days overdue formula help
Look in Help for DateDiff().

HTH
--
-Larry-
--

to add a
the
next to
acomplish

On Friday, November 16, 2007 5:27 AM
Cha wrote:

I want to add a text box next to it and have it appear when its past the
date
I want to add a text box next to it and have it appear when its past the
date and count the days that has gone past. I put this code in the text
box's
control source next to the one that shows the dat

On Friday, November 16, 2007 7:01 AM
Douglas J. Steele wrote:

=IIf(DateDiff("d",[txtPeriodEndDate],Date()) 0,
=IIf(DateDiff("d",[txtPeriodEndDate],Date()) 0,
Format(DateDiff("d",[txtPeriodEndDate],Date()),"0") & " Days Past Due",
Null)


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mail

On Friday, November 16, 2007 7:56 AM
Cha wrote:

Thanks douglas worked like a charm!
Thanks douglas worked like a charm!
--
Newbies need extra loven.........


"Douglas J. Steele" wrote:

EggHeadCafe - Software Developer Portal of Choice
SQL Server 2005 Paging Performance Tip
http://www.eggheadcafe.com/tutorials...paging-pe.aspx