I have to find the number of weekdays between two dates (to the second decimal). For example, if a ticket is opened at 3pm on Friday, and closed at 4pm on Tuesday, I want to exclude the weekend in the day count and have a result similar to 2.04 days.
I WAS using this formula (which includes...
M8KWR--I appreciate the detailed recommendation, but I think you've eclipsed my knowledge of Access. I have no experience with forms, or SQL. Is there any method more straight-forward or less complex?
I have a report that utilizes an underlying query that prompts for a date range (one prompt asks for the beginning date, the next asks for the ending date--format is: "08/15/2004"). The report displays data for whatever date range the user enters. However, I would like to display, at the top...
FWIW, this is the formula I use to convert the original text-formatted dates into actual dates. This formula creates the dates I am trying to query against. The dates were originally in text format like this: 2004-07-23-07.53.28.625619
CDate(Month(Left([TCR_R_INQ_STATUS]![UPDATE_DATE],10)) &...
SkipVought--I got an error message (after I entered the dates in the prompts) that read:
The expression is typed incorrectly, or is too complex to be evaluated. For example, a numberic expression may contain too many complicated elements. Try simplifying the expression by assigning parts of...
I have a table with dates in the format of "8/1/2004 16:56:21 PM" and I am having great difficulty simply running a "between" dates query.
Initially, I had it set up as: between [enter beginning date] and [enter end date]. This skips some records. If I manually put ">=#8/1/2004# and...
Looks like my problem lies in the fact that my dates have times associated. So, my query is searching for records UP TO 09/14/2004 @ 12:00am.
Can anyone recommend a way around this?
Dolfan1873--that's exactly what doesn't work. That's what I mean. It SHOULD work, but it doesn't. So, I'm looking for a work-around. If I put "between [enter beg date] and [enter end date]" it will not pull back the end date, but everything before it.
In other words, if the user input...
FWIW--The standard "between [enter beg date] and [enter end date] brings back all dates EXCEPT the current date. For example, if I put 8/1/2004 to 9/14/2004, it will pull back all date from 8/1/2004 to 8/13/2004. When I use the >=/<=, it does the same thing. However, if I put 8/1/2004 to...
FWIW--The standard "between [enter beg date] and [enter end date] brings back all dates EXCEPT the current date. For example, if I put 8/1/2004 to 9/14/2004, it will pull back all date from 8/1/2004 to 8/13/2004. When I use the >=/<=, it does the same thing. However, if I put 8/1/2004 to...
I have dates in the format of "8/2/2004 10:51 PM" in my tables. I would simply like to allow the user to input two dates, and be able to pull all records within the date range. Here's the odd thing: using "Between [enter beg date] and [enter end date]" does not work. For some reason, it works...
I have dates in the format of "8/2/2004 10:51 PM" in my tables. I would simply like to allow the user to input two dates, and be able to pull all records within the date range. Here's the odd thing: using "Between [enter beg date] and [enter end date]" does not work. For some reason, it works...
I'm not able to subtract the dates now, even though they are in the correct format (6/7/2004 11:56:52 PM). This is due to the fact that they are still formatted as "text." Aside from literally going into the table and changing the format (I get an error that says I don't have enough memory to...
dhookom--To answer your questions:
There is just one table in the make-table query
I was running it across a network. I am currently in the process of copying the database to my desktop, where I will give it another shot. Do you think this is feasible?
When I attempt to run a make-table query, I get this message. I read that it may be due to overly large tables?
The make-table query I am running should create around 200,000 rows, so this may be the issue???
I appear to have the newest update packs. I attempted to compact the database, but...
When I attempt to run a make-table query, I get this message. I read that it may be due to overly large tables?
The make-table query I am running should create around 200,000 rows, so this may be the issue???
I appear to have the newest update packs. I attempted to compact the database, but...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.