|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 14th, 2006, 09:15 PM
posted to microsoft.public.access.queries
|
|||
|
|||
date difference calculation
I need help with this formula please
Todays Date - ReturnDueDate= difference in days * $1.00 * .01 of valueX 
|
|
#2
April 14th, 2006, 09:21 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
date difference calculation
=DateDiff("d", Date(), ReturnDueDate) * .01 * valueX
There's no need to include the $1.00 in the calculation, since multiplying by 1 won't change anything. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Claire" wrote in message ... I need help with this formula please Todays Date - ReturnDueDate= difference in days * $1.00 * .01 of valueX
|
|
#3
April 14th, 2006, 09:24 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
date difference calculation
If you mean you want to calculate the number of days late (or early) and
multiply that by one percent of the value of something then the formula would be. DateDiff("d",[ReturnDueDate],Date()) * [ValueofX] *. 01 "Claire" wrote in message ... I need help with this formula please Todays Date - ReturnDueDate= difference in days * $1.00 * .01 of valueX
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| NETWORKDAYS - Multiple Date Selection | Annabelle | General Discussion | 3 | October 4th, 2005 07:04 PM |
| HELP - Date Range In 1 Cell Calculation | Adam | Worksheet Functions | 6 | September 19th, 2005 08:24 PM |
| Date Range and Average F/X Rate | David | General Discussion | 0 | June 23rd, 2005 02:26 PM |
| date difference using current date is no date is entered | BetsyK | Running & Setting Up Queries | 5 | April 7th, 2005 04:53 PM |
| QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |
Linear Mode
