Re: Days Used function.

2007-01-25 Thread Stephen Weeks
Alan, Tried to upload to leafe.com but slow as f**k, so heres an attachment of program, hope it helps ! Any questions just ask :) Regards Steve -- Stephen Weeks [EMAIL PROTECTED] -- http://www.fastmail.fm - Accessible with your email software or over the web

Re: Days Used function.

2007-01-25 Thread Stephen Weeks
Michael, Tried to upload to leafe.com but it is running like a dog and hanging so i guess there must be a problem ? In case you wanted a copy ive attached the file, good luck, hope it proves useful. Regards Steve -- Stephen Weeks [EMAIL PROTECTED] -- http://www.fastmail.fm - A no

Re: Days Used function.

2007-01-25 Thread Stephen Weeks
OK ... yes ... i am stupid and replied to both Alan and Micheal by using the profox@leafe.com address DUH ! I have sent the replies to the correcty email addresses now. Sorry Regards Steve -- Stephen Weeks [EMAIL PROTECTED] -- http://www.fastmail.fm - Faster than the air-speed velocity of

Re: Days Used function.

2007-01-24 Thread Stephen Weeks
I have a program which we use to calculate time difference, you provide the start date time and the end date and time, you can also specify wether weekends are included or not etc,etc. I will gladly email you a copy Alan. Regards Steve -- Stephen Weeks [EMAIL PROTECTED] --

Re: Days Used function.

2007-01-24 Thread MB Software Solutions
Stephen Weeks wrote: I have a program which we use to calculate time difference, you provide the start date time and the end date and time, you can also specify wether weekends are included or not etc,etc. I will gladly email you a copy Alan. Regards Steve Post it on the ProFox

Re: Days Used function.

2007-01-24 Thread Alan Bourke
Thanks! -- Alan Bourke [EMAIL PROTECTED] -- http://www.fastmail.fm - IMAP accessible web-mail ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Days Used function.

2007-01-23 Thread Alan Bourke
Anyone got a cut-and-paste function for calculating days used? For example if a day is taken as being 6am - 6pm, then I pass it two dates and times and it returns the number of days used. If it's going to involve anything more than cutting and pasting some code into a reply on anyone's part,

Re: Days Used function.

2007-01-23 Thread MB Software Solutions
Alan Bourke wrote: Anyone got a cut-and-paste function for calculating days used? For example if a day is taken as being 6am - 6pm, then I pass it two dates and times and it returns the number of days used. If it's going to involve anything more than cutting and pasting some code into a

Re: Days Used function.

2007-01-23 Thread Alan Bourke
Yes Michael. I know that. However I'd really rather not create a COM DLL in .NET wrapping the relevant function and then have to have my VFP app haul the whole .NET Framework into memory every time I use the COM object. :) -- Alan Bourke [EMAIL PROTECTED] -- http://www.fastmail.fm -

Re: Days Used function.

2007-01-23 Thread MB Software Solutions
Alan Bourke wrote: Yes Michael. I know that. However I'd really rather not create a COM DLL in .NET wrapping the relevant function and then have to have my VFP app haul the whole .NET Framework into memory every time I use the COM object. :) Geee...you mean there really *is* such a

Re: Days Used function.

2007-01-23 Thread MB Software Solutions
Charlie Coleman wrote: At 10:54 AM 1/23/2007 -0500, MB Software Solutions wrote: For example if a day is taken as being 6am - 6pm, then I pass it two dates and times and it returns the number of days used. I'm not sure what you mean. Just to clarify...I'm not the one

RE: Days Used function.

2007-01-23 Thread Allen
365 in all. One for each day of the year but it screws up on leap years :) Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 23 January 2007 16:14 Alan Bourke wrote: Yes Michael. I know that. However I'd really rather

Re: Days Used function.

2007-01-23 Thread Ted Roche
On 1/23/07, Alan Bourke [EMAIL PROTECTED] wrote: A day is 6am to 6am (not 6pm like my original post, sorry) therefore the above uses up one day since it is within a 6am-6am timespan. So, #DEFINE SecondsInADay 24*3600 Function DaysUsed(tStartDateTime, tEndDateTime) Return

Re: Days Used function.

2007-01-23 Thread Ricardo Aráoz
Alan Bourke wrote: Yes Michael. I know that. However I'd really rather not create a COM DLL in .NET wrapping the relevant function and then have to have my VFP app haul the whole .NET Framework into memory every time I use the COM object. :) (datetime(year1, month1, day1, hour1, min1,