Count days overdue formula help

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" <Chad.RemoveThis@discussions.microsoft.com> wrote in message
> news:23922F5F-0FE3-4B24-AC68-84DBE8956382@microsoft.com...
> > 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" <Chad DeleteThis @discussions.microsoft.com> wrote in message
news:A8813855-4043-43D5-9A25-2B51B878EB5F@microsoft.com...
> 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" <Chad DeleteThis @discussions.microsoft.com> wrote in message
>> news:23922F5F-0FE3-4B24-AC68-84DBE8956382@microsoft.com...
>> > 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" <Chad DeleteThis @discussions.microsoft.com> wrote in message
> news:A8813855-4043-43D5-9A25-2B51B878EB5F@microsoft.com...
> > 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" <Chad DeleteThis @discussions.microsoft.com> wrote in message
> >> news:23922F5F-0FE3-4B24-AC68-84DBE8956382@microsoft.com...
> >> > 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:

Re: 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/aspnet/fe1e8749-26dd-4db7-9c18-b6...c39aa73

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:
>
> Re: 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/aspnet/fe1e8749-26dd-4db7-9c18-b6...c39aa73