pulling accounted time from a case entry

[offerlam]

Hi all

I'm using the accounted to keep track of how much my clients should pay me... nothing special there..

but in some cases I can have a case streatching for months on end.. here i have a problem cause really would like to send a bill each month..

The only way I have seen i can pull any kind of accounted time data is from the statistics but its from the entire case..

So a case that may stretch over serveral months can and will have serveral case entries describing different types of work being during that time...

what im looking for is a way to pull accounted time for a single case entry or maybe multiple case entries... or maybe be able to set start and a end date and see the accounted time for that...

I have made a statistik pulling among other things accounted time in this statistik I can set a start and a end date but it still shows all accounted time for that date NOT repspecting the time frame i set

Any solution?

THANKS

Casper

[crythias]

viewtopic.php?f=60&t=12546

[offerlam]

Thanks..

I have seen that post before but this is something my book keeper was going to use and even though the be the correct answer I was looking for a simpler solution.

As earwax also says in the post you linked his also looking for this to be pulled with a report or something...

I was hoping the 3-4 years past than that this would maybe have been done in a update or something..

[crythias]

I can't know what you have seen, needed, tried, or didn't like until you specify.

If you want something "better", ask a better question. Specifically: "I need these fields in this format"

Feel free to modify viewtopic.php?f=60&t=17033 to provide a url with your data.
If you don't know how to make a web form or provide ways to put start and end values to a query, you may ask here, but at least please try to do some searches on "mysql where between" and maybe "date_sub".

For what has been done, the query hasn't changed because nobody has asked for a better one, and especially not in specific enough terms that required any changes.

[offerlam]

dude i ment no disrepect!!

im just VARY new to this side of IT .. so i don't really know what technical terms to search about..

And i just assumed my focus on the statistik feature mayby showed what way i was haeding or leaning but i can see that we come from two differnt worlds and I should try and specify my requirement more.. that being said i will try some of the stuff you mentioned.. maybe i can learn the rest on my own..

Thanks

Casper

[crythias]

I don't mean any disrespect either. My comments aren't to be taken personally, except so that you, and others who might ask questions on this forums, can ask effective questions that both pique our interest to answer and allow us to provide relevant answers to the questions :).

Anyone's post on any forum might receive any of the following responses:

1) Nothing
2) A request for clarification
3) Ridicule for asking the question
4) Frustration response for not doing a basic search, which is what most of us will be doing to answer a question
5) Frustration response for throwing in "Urgent"
6) Links to the searches we've performed
7) answers to the questions because there is an answerable question
8) Other