Re: Fun with date calculations in VFP

In my mind was implying a DVD & Floppy Disk and not internal system drive(s). On Thu, May 31, 2018 at 8:34 AM, Ted Roche wrote: > On Tue, May 29, 2018 at 1:04 PM, Stephen Russell > wrote: > > Who has anything like a disk drive on a laptop today? > > > > Pretty sure everyone has something

Re: Fun with date calculations in VFP

On Tue, May 29, 2018 at 1:04 PM, Stephen Russell wrote: > Who has anything like a disk drive on a laptop today? > Pretty sure everyone has something "like" a disk drive -- isn't that what the D in SSD and HDD stand for? Even my Chromebook and Android phone have something "like" a disk drive.

Re: Fun with date calculations in VFP

At 12:37 2018-05-21, Vince Teachout wrote: On 05/20/18 3:31 PM, Ted Roche wrote: On Sun, May 20, 2018 at 1:39 PM, Gene Wirchenko wrote: thedate=date(,12,31) && Handle this extreme case. And that, kids, is why we call it "The Y10K crisis..." I looking forward to all the

Re: Fun with date calculations in VFP

On 05/29/18 1:04 PM, Stephen Russell wrote: Who has anything like a disk drive on a laptop today? Good point. You think that problem might get worse by 9,999 A.D.? --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

Re: Fun with date calculations in VFP

Who has anything like a disk drive on a laptop today? On Mon, May 21, 2018 at 2:37 PM, Vince Teachout wrote: > On 05/20/18 3:31 PM, Ted Roche wrote: > >> On Sun, May 20, 2018 at 1:39 PM, Gene Wirchenko wrote: >> >> thedate=date(,12,31) && Handle this extreme case. >>> >> >> And

Re: Fun with date calculations in VFP

On 2018-05-21 15:37, Vince Teachout wrote: On 05/20/18 3:31 PM, Ted Roche wrote: On Sun, May 20, 2018 at 1:39 PM, Gene Wirchenko wrote: thedate=date(,12,31) && Handle this extreme case. And that, kids, is why we call it "The Y10K crisis..." I looking forward to all the

Re: Fun with date calculations in VFP

On 05/20/18 3:31 PM, Ted Roche wrote: On Sun, May 20, 2018 at 1:39 PM, Gene Wirchenko wrote: thedate=date(,12,31) && Handle this extreme case. And that, kids, is why we call it "The Y10K crisis..." I looking forward to all the I'm going to make when people call me in

RE: Fun with date calculations in VFP

Lol Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Tuesday, May 22, 2018 8:41 PM To: profoxt...@leafe.com Subject: RE: Fun with date calculations in VFP At 08:38 2018-05-22, "Paul H. Tarver" <p.

RE: Fun with date calculations in VFP

At 08:38 2018-05-22, "Paul H. Tarver" <p...@tpcqpc.com> wrote: -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Monday, May 21, 2018 9:03 PM To: profoxt...@leafe.com Subject: Re: Fun with date calculations in VF

RE: Fun with date calculations in VFP

I'm starting to feel the panic rise...No clients calling yet, but it's coming... Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Monday, May 21, 2018 9:03 PM To: profoxt...@leafe.com Subject: Re: Fun with date

Re: Fun with date calculations in VFP

At 12:31 2018-05-20, Ted Roche wrote: On Sun, May 20, 2018 at 1:39 PM, Gene Wirchenko wrote: > thedate=date(,12,31) && Handle this extreme case. And that, kids, is why we call it "The Y10K crisis..." It is not a crisis yet. You have

Re: Fun with date calculations in VFP

On Mon, May 21, 2018 at 3:37 PM, Vince Teachout wrote: > > nb: Don't lose vfp install disk before then! > Gotcha covered: https://imgur.com/a/NPMsnUL Hmm... might need to find a disk drive too. And a controller. Edge-connector cable... hmm -- Ted Roche Ted Roche &

RE: Fun with date calculations in VFP

k) - loDaysOfWeek.Item(CDOW(ldLastDate,7) EndIf Return ldLastDate -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: 20 May 2018 20:32 To: profox@leafe.com Subject: Re: Fun with date calculations in VFP On Sun, May 20, 2018 at 1:39 PM, Gene Wirch

Re: Fun with date calculations in VFP

On Sun, May 20, 2018 at 1:39 PM, Gene Wirchenko wrote: > thedate=date(,12,31) && Handle this extreme case. And that, kids, is why we call it "The Y10K crisis..." -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

Re: Fun with date calculations in VFP

At 08:30 2018-05-18, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2018-05-16 18:02, Ted Roche wrote: LastDayOfMonth() or LDOM back in my 8.3 days, was always a popular request: http://fox.wikis.com/wc.dll?Wiki~FindingTheLastDayOfTheMonth~VB Ed Leafe had shared a ton of date

Re: Fun with date calculations in VFP

Pro: It's magic ! > (¸.·``··* > > > > > -Ursprüngliche Nachricht- > Von: ProFox <profox-boun...@leafe.com> Im Auftrag von Frank Cazabon > Gesendet: Freitag, 18. Mai 2018 18:41 > An: profox@leafe.com > Betreff: Re: Fun with date calculations in VFP > >

AW: Fun with date calculations in VFP

Auftrag von Frank Cazabon Gesendet: Freitag, 18. Mai 2018 18:41 An: profox@leafe.com Betreff: Re: Fun with date calculations in VFP Lots of spare time today so some hopefully constructive criticism: :) I would redo some of that code to get away from CTOD() as that will fail depending on SET STRICTDAT

Re: Fun with date calculations in VFP

Lots of spare time today so some hopefully constructive criticism: :) I would redo some of that code to get away from CTOD() as that will fail depending on SET STRICTDATE and if SET DATE is anything besides MDY. I have a feeling that your first day of week and last day of week will be

Re: Fun with date calculations in VFP

On 2018-05-16 18:02, Ted Roche wrote: LastDayOfMonth() or LDOM back in my 8.3 days, was always a popular request: http://fox.wikis.com/wc.dll?Wiki~FindingTheLastDayOfTheMonth~VB Ed Leafe had shared a ton of date functions for VFP years ago. Here's what I have in my framework from Ed:

RE: Fun with date calculations in VFP

:29 To: ProFox Email List <profox@leafe.com> Subject: Re: Fun with date calculations in VFP Updated. Clearly a lot of stuff left to do on this class! I got distracted by "work" but feel free to clone and contribute. set proc to datetime addi _vfp.addoboject("DateTime"

AW: Fun with date calculations in VFP

Hmmm.. You know that "SaltyDog" is actually Eric's page ? wOOdy -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Alan Bourke Gesendet: Donnerstag, 17. Mai 2018 14:12 An: profoxt...@leafe.com Betreff: Re: Fun with date calculations in VF

Re: Fun with date calculations in VFP

On Thu, May 17, 2018 at 8:11 AM, Alan Bourke wrote: > There's a VFP implementation of the C# String.Format() here: > http://saltydogllc.com/string-format-for-visual-foxpro/ Cool! Check that off the list! -- Ted Roche Ted Roche & Associates, LLC

Re: Fun with date calculations in VFP

There's a VFP implementation of the C# String.Format() here: http://saltydogllc.com/string-format-for-visual-foxpro/ -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Fun with date calculations in VFP

You have a set of Add functions: AddYears, AddDays, AddHours, Minutes, Seconds, Ticks... where's AddMonth, besides the obvious GOMONTH()? Time support native in VFP has always been weak. I wrote a s2hms and hms2s to convert between seconds and HH:MM:SS strings. DTOT converts a Data to a datetime

Re: Fun with date calculations in VFP

Updated. Clearly a lot of stuff left to do on this class! I got distracted by "work" but feel free to clone and contribute. set proc to datetime addi _vfp.addoboject("DateTime", "DateTime") && Now it's always available ? _vfp.DateTime.FirstDayOfMonth()&& 05/01/2018 ?

Re: Fun with date calculations in VFP

LastDayOfMonth() or LDOM back in my 8.3 days, was always a popular request: http://fox.wikis.com/wc.dll?Wiki~FindingTheLastDayOfTheMonth~VB -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com

Re: Fun with date calculations in VFP

gt; > > -Ursprüngliche Nachricht- > Von: ProFox <profox-boun...@leafe.com> Im Auftrag von Eric Selje > Gesendet: Dienstag, 15. Mai 2018 22:20 > An: ProFox Email List <profox@leafe.com> > Betreff: Re: Fun with date calculations in VFP > > I've started a class for a

AW: Fun with date calculations in VFP

ProFox Email List <profox@leafe.com> Betreff: Re: Fun with date calculations in VFP I've started a class for a C# like DateTime static class here: https://github.com/eselje/FoxTypes/blob/master/FT_DATETIME.md ___ Post Messages to: ProF

Re: Fun with date calculations in VFP

I've started a class for a C# like DateTime static class here: https://github.com/eselje/FoxTypes/blob/master/FT_DATETIME.md I may steal some of the ideas here to embellish it, but if you have time and want to contribute please clone this repo and submit a pull request when done. It's pretty

Re: Fun with date calculations in VFP

On Tue, May 8, 2018 at 5:39 PM, Richard Kaye wrote: > I owe you a Scotch next time you're in the area. > Deal! -- Ted Roche & Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription

RE: Fun with date calculations in VFP

I owe you a Scotch next time you're in the area. -- rk -Original Message- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Ted Roche Sent: Tuesday, May 08, 2018 5:15 PM To: profoxt...@leafe.com Subject: Re: Fun with date calculations in VFP Did I mention I like dat

Re: Fun with date calculations in VFP

an ICASE? (I haven't quite wrapped my head around what you're doing >>> there but it seems like there are 3 states?) >>> >>> m.theOffset=ICASE(theDiff>3, 7-m.theDiff,theDiff<-3, 7+m.theDiff, m.theDiff) >>> >>> -- >>> >>> rk

Re: Fun with date calculations in VFP

9)+CDOW(olddate(DATE()+1,-2)) >>> ? [Same day 3 years ago: ] >>> ?? olddate(DATE()+1,-3) >>> ?? CHR(9)+CDOW(olddate(DATE()+1,-3)) >>> ? [Same day 10 years ago: ] >>> ?? olddate(DATE()+1,-10) >>> ?? [ ]+CDOW(olddate(DATE()+1,-10)) >>> >>&

Re: Fun with date calculations in VFP

.theDiff, m.theDiff) > > -- > > rk > > -Original Message- > From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Ted Roche > Sent: Tuesday, May 08, 2018 3:25 PM > To: profoxt...@leafe.com > Subject: Re: Fun with date calculations in VFP > >

RE: Fun with date calculations in VFP

ehalf Of Ted Roche Sent: Tuesday, May 08, 2018 3:25 PM To: profoxt...@leafe.com Subject: Re: Fun with date calculations in VFP GOMONTH() just moves back to 2/28 on years that don't have a 2/29, so your olddate({^2016-02-29},-2) gives you the previous Tuesday, 2/24/2014. Hmmm. That's an OBO. It

Re: Fun with date calculations in VFP

f the week > LOCAL m.theDiff, m.theOffset > m.theDiff=DOW(m.theDate)-DOW(GOMONTH(m.theDate, m.offset*12)) > m.theOffset=IIF(theDiff>3, 7-m.theDiff, m.theDiff) > RETURN GOMONTH(m.theDate, m.offset*12) + m.theOffset > > ENDFUNC > > -- > > rk > > -Original Message---

RE: Fun with date calculations in VFP

ech <profoxtech-boun...@leafe.com> On Behalf Of Gene Wirchenko Sent: Tuesday, May 08, 2018 12:46 PM To: profoxt...@leafe.com Subject: RE: Fun with date calculations in VFP At 06:27 2018-05-08, Richard Kaye <rk...@invaluable.com> wrote: >The latter. And that was the approach I was ju

Re: Fun with date calculations in VFP

Rofl Op di 8 mei 2018 16:27 schreef Ted Roche : > On Tue, May 8, 2018 at 11:23 AM, Richard Kaye > wrote: > > Another guy that fixes his typos the 2nd time...  Thanks, Ted! > > :) > > Well, the first version ran great in GMail! The second version I >

RE: Fun with date calculations in VFP

At 06:27 2018-05-08, Richard Kaye wrote: The latter. And that was the approach I was just working through. What about the week every few years that you will be disregarding? A year has 52 weeks plus one or two days. [snip] Sincerely, Gene Wirchenko

RE: Fun with date calculations in VFP

:00 PM To: profoxt...@leafe.com Subject: RE: Fun with date calculations in VFP Richard, It was the Google Effect ... just like mine!! Dave Crozier Software Development Manager Flexipol Packaging Ltd. -Original Message- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Ted Roche S

RE: Fun with date calculations in VFP

t: 08 May 2018 16:53 To: profox@leafe.com Subject: RE: Fun with date calculations in VFP lol -- rk -Original Message- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Ted Roche Sent: Tuesday, May 08, 2018 11:28 AM To: profoxt...@leafe.com Subject: Re: Fun with date calculat

RE: Fun with date calculations in VFP

lol -- rk -Original Message- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Ted Roche Sent: Tuesday, May 08, 2018 11:28 AM To: profoxt...@leafe.com Subject: Re: Fun with date calculations in VFP On Tue, May 8, 2018 at 11:23 AM, Richard Kaye <rk...@invaluable.c

Re: Fun with date calculations in VFP

On Tue, May 8, 2018 at 11:23 AM, Richard Kaye wrote: > Another guy that fixes his typos the 2nd time...  Thanks, Ted! :) Well, the first version ran great in GMail! The second version I actually tried running in VFP ;) ___ Post

RE: Fun with date calculations in VFP

Another guy that fixes his typos the 2nd time...  Thanks, Ted! -- rk -Original Message- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Ted Roche Sent: Tuesday, May 08, 2018 11:12 AM To: profoxt...@leafe.com Subject: Re: Fun with date calculations in VFP Or, clea

Re: Fun with date calculations in VFP

Or, cleaned up a bit: FUNCTION olddate(thedate, offset) * parameters: thedate: date to start from * offset: number of years offset, positive or negative * returns: nearest date to the offset that falls on the same day of the week LOCAL thediff, theoffset thediff =

Re: Fun with date calculations in VFP

On Tue, May 8, 2018 at 9:14 AM, Ted Roche wrote: > So, do you want a function that returns the second Tuesday in May or > one that returns the Tuesday closest to May 8? Both would fit the > specs. > > Date math was one of my many VFP hobbies. There were lots of date math >

Re: Fun with date calculations in VFP

I found a millisecond approach a while back that hasn't given us any issues yet 60480 milliseconds in a week is the fact I base the code on. var date:Date = new Date(, MM, DD); Datetime lastyear = date.setMilliseconds(date.milliseconds - 60480 * 52); On Tue, May 8, 2018 at 8:07

RE: Fun with date calculations in VFP

To: profoxt...@leafe.com Subject: RE: Fun with date calculations in VFP Error Fix: The function should read as follows: *** * Mirrors the SQL DateAdd() function * Written By: R.D.Crozier * From an idea in MSDN Forum * Function DateAdd(tcInterval,tnIncrement,tdDateTime) L

RE: Fun with date calculations in VFP

Error Fix: The function should read as follows: *** * Mirrors the SQL DateAdd() function * Written By: R.D.Crozier * From an idea in MSDN Forum * Function DateAdd(tcInterval,tnIncrement,tdDateTime) Local strTime As String,strOldExact As String,strOldDate As String,vReturn

RE: Fun with date calculations in VFP

e: Fun with date calculations in VFP So, do you want a function that returns the second Tuesday in May or one that returns the Tuesday closest to May 8? Both would fit the specs. Date math was one of my many VFP hobbies. There were lots of date math answers in Ask Advisor. GOMONTH() gets you to th

Re: Fun with date calculations in VFP

So, do you want a function that returns the second Tuesday in May or one that returns the Tuesday closest to May 8? Both would fit the specs. Date math was one of my many VFP hobbies. There were lots of date math answers in Ask Advisor. GOMONTH() gets you to the year you want, then you can use

RE: Fun with date calculations in VFP

clear set century on dDate=Date() ? DateAdd("YY", 5, dDate) ? DateAdd("WEEK", 5, dDate) * return * Mirrors TSQL DateAdd() Function * Example: * ? DateAdd("YY", 2, Date()) * Function DateAdd(tcInterval,tnIncrement,tdDateTime) Local strTime As String,strOldExact As String,strOldDate As

Fun with date calculations in VFP

While doing my due diligence on the subject I thought I’d toss it out here in case someone already has a function handy that will do this, thus saving me the effort of thinking too hard too early in the day.  Here’s the goal. I want to take a date, say today, Tuesday May 8, 2018 and figure

Re: Date calculations.

On 3/30/07, Sietse Wijnker [EMAIL PROTECTED] wrote: Hmm, the start date isn't relevant. I think start date is relevant. 1. How many months and days are there in 59 days if you start on January 1st? 2. How about 62 days? 3. What if you start on January 15th? 4. June 1st? June 15th? June

RE: Date calculations.

, March 29, 2007 6:49 AM To: [EMAIL PROTECTED] Subject: Re: Date calculations. Sietse Wijnker wrote: And my stab at it: IMHO, less calculations, less problems FUNCTION verbosedate LPARAMETERS tnTotDays LOCAL lnYears, lnMonths, lnDays LOCAL ldDate1, ldDate2 ldDate1 = DATE() ldDate2

RE: Date calculations.

the 1 to the equation would result in a difference of 1 day? Sietse -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens aihsan Verzonden: donderdag 29 maart 2007 12:01 Aan: [EMAIL PROTECTED] Onderwerp: RE: Date calculations. I think to get correct answer, two

RE: Date calculations.

Thanks Ken Bryant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Kixmoeller/fh Sent: Tuesday, March 27, 2007 7:58 PM To: profox@leafe.com Subject: Re: Date calculations. On Mar 27, 2007, at 6:14 PM, Bryant Minard wrote: If I have variable

RE: Date calculations.

This works for me. Thanks Bryant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Tuesday, March 27, 2007 11:56 PM To: ProFox Email List Subject: Re: Date calculations. Bryant Minard wrote: If I have variable (d = 397

RE: Date calculations.

) lnDays = DAY(ldDate2) - DAY(ldDate1) ? lnYears, lnMonths, lnDays RETURN ENDFUNC -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Vince Teachout Verzonden: woensdag 28 maart 2007 5:56 Aan: [EMAIL PROTECTED] Onderwerp: Re: Date calculations. Bryant Minard

Re: Date calculations.

Sietse Wijnker wrote: And my stab at it: IMHO, less calculations, less problems FUNCTION verbosedate LPARAMETERS tnTotDays LOCAL lnYears, lnMonths, lnDays LOCAL ldDate1, ldDate2 ldDate1 = DATE() ldDate2 = DATE() + tnTotDays lnYears = YEAR(ldDate2) - YEAR(ldDate1) lnMonths =

Date calculations.

If I have variable (d = 397, the difference between two dates), how can I show that in years, months and days? (example 1 year, 1 month and 1 day) Has anyone written a function to do something like this? Bryant -- No virus found in this outgoing message. Checked by AVG Free Edition.

Re: Date calculations.

On Mar 27, 2007, at 6:14 PM, Bryant Minard wrote: If I have variable (d = 397, the difference between two dates), how can I show that in years, months and days? (example 1 year, 1 month and 1 day) Has anyone written a function to do something like this? This is one I adapted that does

RE: Date calculations.

] [mailto:[EMAIL PROTECTED] On Behalf Of Bryant Minard Sent: Tuesday, March 27, 2007 6:15 PM To: profox@leafe.com Subject: Date calculations. If I have variable (d = 397, the difference between two dates), how can I show that in years, months and days? (example 1 year, 1 month and 1 day) Has anyone

Re: Date calculations.

john harvey wrote: Gee, do you think maybe they didn't want to get caught forgetting some obscure bit of a conversation during 8 hours of grilling, like Libbey did? How'd you like to sit on the hot seat for a day being asked the same question in a multitude of ways, and if you forget some

Re: Date calculations.

On Mar 27, 2007, at 7:06 PM, john harvey wrote: Gee, do you think maybe they didn't want to get caught forgetting some obscure bit of a conversation during 8 hours of grilling, like Libbey did? I didn't know Libbey() or GBW() functions calculated date differences. Please send those

RE: Date calculations.

27, 2007 7:19 PM To: profox@leafe.com Subject: Re: Date calculations. On Mar 27, 2007, at 7:06 PM, john harvey wrote: Gee, do you think maybe they didn't want to get caught forgetting some obscure bit of a conversation during 8 hours of grilling, like Libbey did? I didn't know Libbey

Re: Date calculations.

are witch hunting. Wow, are you coming from another planet or what? What does this have to do with Date calculations? -- Ed Leafe -- http://leafe.com -- http://dabodev.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance

Re: Date calculations.

On Mar 27, 2007, at 7:25 PM, Ed Leafe wrote: Wow, are you coming from another planet or what? You are just asking this question now?!?!?!?! gdr ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: Date calculations.

It wasn't the wrong post, I just happened to know y'all were thinking about this stuff! Doh! JH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: Tuesday, March 27, 2007 7:18 PM To: profox@leafe.com Subject: Re: Date

RE: Date calculations.

I've started randomizing my responses JH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: Tuesday, March 27, 2007 7:26 PM To: ProFox Email List Subject: Re: Date calculations. On Mar 27, 2007, at 8:06 PM, john harvey wrote: Gee, do

Re: Date calculations.

On Mar 27, 2007, at 7:38 PM, john harvey wrote: I've started randomizing my responses Boy, did you open a really big door there... Resist! Too easy! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

[OT] Re: Date calculations.

are witch hunting. JH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bryant Minard Sent: Tuesday, March 27, 2007 6:15 PM To: profox@leafe.com Subject: Date calculations. If I have variable (d = 397, the difference between two dates), how can I show

RE: [OT] Re: Not Date calculations.

gwb and his minion gonzales fired all of the U.S. Attys when they came into office in 2001, just as Clinton did and every other President of a GWB did NOT fire all the US Attys. Over 1/3rd tendered their resignations when the Republicans took over the presidency. But then the bush crime

Re: Date calculations.

john harvey wrote: I've started randomizing my responses JH LOL! That'll keep folks on their toes! ;-) -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions!

RE: Date calculations.

are witch hunting. Wow, are you coming from another planet or what? What does this have to do with Date calculations? Retirement is hell I guess. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 A good way to judge people is by observing how they treat those

Re: Date calculations.

Bryant Minard wrote: If I have variable (d = 397, the difference between two dates), how can I show that in years, months and days? (example 1 year, 1 month and 1 day) Has anyone written a function to do something like this? Here's how I'd do it: VerboseDate(397) FUNCTION verbosedate

RE: Date calculations.

What does this have to do with Date calculations? Retirement is hell I guess. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 I HAD to go fishing yesterday to get some more bass for my pond. I caught ten and brought them back in a large cooler with an aeriator

Re: [OT] Re: Date calculations.

Of Bryant Minard Sent: Tuesday, March 27, 2007 6:15 PM To: profox@leafe.com Subject: Date calculations. If I have variable (d = 397, the difference between two dates), how can I show that in years, months and days? (example 1 year, 1 month and 1 day) Has anyone written a function