September 13, 2005 at 1:34 pm
Hi I have table which has the following fields:
startDate - 08/01/1005 06:00:00 and
endDate - 09/01/2005 21:00:00
Each Field engineer is scheduled to work on the dates mentioned above. My requiremnt is to plot on a chart for each hour on between the 2 dates on Dundas. I have no clue how to get this working..
Would appreciate any help on this.
Thanks
September 13, 2005 at 1:42 pm
I don't get it. You have a start and an end date and you need to plot the hours between them? But you haven't given any that you need to plot...
Or do you just need to enumerate (list) each hour between the start and end? That could be done with a simple WHILE loop, depending on the output needed.
More information is needed to provide specific help on this.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 13, 2005 at 1:58 pm
Actually, it can easily be done with a straight select... but we still need to know what data you need returned to the client.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply