A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
DATE DIF EXPRESSION by MaryLou
I have a duedate and recdate that I would like to know what the days between are I have tried DATEDIF(,, "D") it is unidentified. Help. Mary Lou
January 25th, 2006 12:04 AM
by MGFoster Go to last post
2 87
Date Dif shown in Yr/mo by KAnoe
How do you make the date difference between now() and show up as year/month Thanks Keith
November 30th, 2006 04:58 PM
by KAnoe Go to last post
0 90
Date Diff by PJ
I am new to Access.I work for a multi billion $ company and believe it not have no expertise in Access.We have Access 2002.I created a table which has 2 ...
March 2nd, 2008 01:10 AM
by raskew via AccessMonster.com Go to last post
1 61
Date Diff by Dan @BCBS
This expression in a query returns a date differance. If the dates in both values are the same it returns "0" which makes sense but is there a way to default...
April 29th, 2008 09:51 PM
by Marshall Barton Go to last post
3 91
Date Diff by lmossolle
I am using office 2007 and in need of help to find the age of item. Could someone please assist? I have a table named table, I have a Date_Rec ands would...
May 27th, 2009 08:23 PM
by Allie12380 Go to last post
6 84
Date Diff by D. M.
Hello, In my property management database, I'm trying to calculate how many months are left (from today) on a lease (based on ). How would I write this...
June 28th, 2006 01:24 AM
by Steve Schapel Go to last post
6 71
Date diff excluding weekends by DeanT
Is there a formula I can use in a query to calc the diff between 2 dates excluding weekends (Sat and Sun) ? Thanks
December 19th, 2007 03:51 AM
by raskew via AccessMonster.com Go to last post
1 58
Date Diff Function by [email protected]
Hi, I have two columns. each column has a date and a time. i.e. a date when the ticket was opened and a date when it was closed. I want to a third column...
October 14th, 2008 12:24 AM
by John Spencer Go to last post
4 71
Date difference by EMILYTAN via AccessMonster.com
May I know how to do a date different between a given date in a field and today's date. I want to add a field on aging and calculate the date difference in...
July 31st, 2007 10:24 AM
by Stefan Hoffmann Go to last post
4 82
date difference by Arul
I have two date columns, create_date, closed_date. I'm trying to get the number of hours between these two dates that includes only work days (M, T, W, TH,...
August 23rd, 2004 04:36 PM
by Allen Browne Go to last post
1 72
Date Difference - Weekends & Holidays by Tcs
I need to calculate the number of days between two dates. I went searching this group and found what I needed, in a 2003 & 2005 posting. The 2005 posting...
August 28th, 2006 03:05 PM
by Tcs Go to last post
4 82
date difference calculation by Claire
I need help with this formula please Todays Date - ReturnDueDate= difference in days * $1.00 * .01 of valueX
April 14th, 2006 09:24 PM
by John Spencer Go to last post
2 53
Date Difference Calculation by Deb
Using Access 2003. Have a table with hospital admissions. Am trying to retrieve records where a person has an admission within 30 days of another admission. ...
November 10th, 2005 05:15 AM
by Tom Ellison Go to last post
4 88
Date Difference Exclude Weekends by NadSadBad
In a query, how can you calculate the difference between 2 dates (Date1 and Date2) but exclude weekends. I am trying to return the number of working days...
June 13th, 2005 03:37 PM
by Dennis Go to last post
2 91
date difference expression in query by D
I need to calculate a couple of date-related values, one is a date 6 months from the start date, the other is the age today. I can get this information by...
June 23rd, 2005 01:28 AM
by John Vinson Go to last post
4 95
Date difference for single field by accesskastle
Hi. I'd appreciate any help with this problem. I've read threads on this before, but couldn't get it right. I want to calculate the difference between...
April 11th, 2007 01:13 AM
by Tom Ellison Go to last post
3 108
date difference in days by InventoryQueryGuy
Can you help??? I have a Column called T.StartDate and I would like to calculate the difference in time between then and Now() and have the result returned in...
August 25th, 2006 04:19 PM
by Jeff Boyce Go to last post
3 68
Date Difference In Query by Ange Kappas
Hi, I have a query in the Design View, where I have grouped all relevant fields like RESERVENAME ,ROOMNO, ARRIVAL and DEPARTURE. I want to add a...
February 7th, 2008 02:08 PM
by Ange Kappas Go to last post
2 107
Date Difference limited to 100 years by Richard S.
I have a query to extract all persons with an age eaual to or greater than a user-entered paramater (criteria). The expression (Year(Date())-Year(.)) when...
July 15th, 2009 10:22 PM
by Richard S. Go to last post
6 110
Date difference to show in years and months by Owl
Question 1 (the most important of the 3 related questions) I have a date of birth field(DOB) and I want to get the age in current years and months to display...
September 19th, 2009 03:17 PM
by Douglas J. Steele[_3_] Go to last post
2 154
Post New Thread


Display Options
Showing threads 9841 to 9860 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.