Search results

and I thank you very much for your solution and your patience with my initial mistake.

Ugh...sorry. It must be too early in the morning to be looking at this. You guys were right, I wrote down the values wrong. Sorry. To solve issues like this it's much harder if you don't get the right info.

I have some values being passed to my query in a date field that I can't figure out how to covert to dd/mm/yyyy. Here are a couple of the dates 109415 = 04/15/2009 110112 = 11/12/2010 1100208 = 02/08/2010 Anyone have a method for getting this through as a "regular" date for me? Thanks

ISO 8601 has a standardization for dates / times that our company just recently settled on as well. As far as I can tell the rest of the computing world has not embraced it in any standard form and it takes a calculation, like the one above, to keep the week designations in check.

Galaxiom: That doesn't return the ISO week....but thanks HTC: I read that post a couple of weeks ago and it requires 2 user defined functions AND I never got them both to work. More complicated than I was hoping for, but maybe I should revisit....

I would like to duplicate an excel formula that converts a date to ISO Week, but it is daunting to look at. I would consider using a user created function for it, but have never had luck getting them to work. Here is the excel...

I modified it to remove the breakout of days...limited it to the last 10 days and I'll subtract that from another 90 day query and get what I need. Very helpful. Thanks!

Well...that works. It doesn't exactly get me what I need, but close. I guess if it only returned th value for 80: 89 I would be better off.

Try this...One person who should have 90 day tardies and others.

Well...it's a sub-query. The initial query of the DB table isolates the incidents by date. Now I want to simply count the incidents and group them by different date ranges... Last 90 Last 80 Last 70...and so on I guess I could send the sub-query output in a file. Let me try that. Jon

I considered that and had to changed it to what is shown. Both ways return the same value, so I guess the "between" works both ways. Sigh. Thanks so far though...

Thanks. I have seen that as a possible issue referenced elsewhere, but I changed it and it had no affect on the output. Example: Jimmy Johnson Last90 = 20 tardies and all dates = 20 tardies. All of Jimmy's tardies are not, however, in the last 90 days.

Hi, I'm trying to find a count of events in my table that occur in the last 90 days. This is the formula I'm using, but the value being returned is the count of the entire set of occurrences. Last90: DCount("[LastOfEXCEPTION_CODE]","TardySelect","[DATE] between Date() and Date()-90") What...