|
|
| pxriet 2005-06-29, 8:25 pm |
| How do I do a simple calculation to determine the number of days between two
date fields?
Do the date fields need to be formatted a certain way?
| |
| Mike Gagnon 2005-06-29, 8:25 pm |
| dDate = ctod('12/25/2005')
dDate2 = DATE()
dDate3 = dDate2-dDate
? dDate3
179 days until christmas!
"pxriet" <pxriet@discussions.microsoft.com> wrote in message
news:1098B1C3-8B5E-40D6-835A- CB14AAFB7B8A@microso
ft.com...
> How do I do a simple calculation to determine the number of days between
> two
> date fields?
>
> Do the date fields need to be formatted a certain way?
| |
| pxriet 2005-06-29, 8:25 pm |
| I am working in a 5,000,000 record database, and I will need to do several of
these type calculations within my program. I need more of a replace...for
calculation if it is possible
"Mike Gagnon" wrote:
> dDate = ctod('12/25/2005')
>
> dDate2 = DATE()
>
> dDate3 = dDate2-dDate
>
> ? dDate3
>
> 179 days until christmas!
>
>
> "pxriet" <pxriet@discussions.microsoft.com> wrote in message
> news:1098B1C3-8B5E-40D6-835A- CB14AAFB7B8A@microso
ft.com...
>
>
>
| |
| Fred Taylor 2005-06-29, 8:25 pm |
| What kind of calculation do you need to do? Date calculations are easy in
VFP as Mike demonstrated.
--
Fred
Microsoft Visual FoxPro MVP
"pxriet" <pxriet@discussions.microsoft.com> wrote in message
news:DCC195EB-D34F-48DB-8B91- 70AB798F9B6B@microso
ft.com...[color=darkred]
>I am working in a 5,000,000 record database, and I will need to do several
>of
> these type calculations within my program. I need more of a replace...for
> calculation if it is possible
>
> "Mike Gagnon" wrote:
>
| |
| pxriet 2005-06-30, 3:24 am |
| I have a huge database and I'm calculating the number of days between four
different date fields. (Field1 - field2); (field2 - field3); (field3 -
field4)
"Fred Taylor" wrote:
> What kind of calculation do you need to do? Date calculations are easy in
> VFP as Mike demonstrated.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "pxriet" <pxriet@discussions.microsoft.com> wrote in message
> news:DCC195EB-D34F-48DB-8B91- 70AB798F9B6B@microso
ft.com...
>
>
>
| |
| Cindy Winegarden 2005-06-30, 9:24 am |
| Hi Pxriet,
Replace All ;
Result1 With Date1 - Date2, ;
Result2 With Date2 - Date3, :
Result3 With Date3 - Date4 ;
In MyTable
--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"pxriet" <pxriet@discussions.microsoft.com> wrote in message
news:132DE704-E424-4233-994B- 05F9F08C8EDC@microso
ft.com...[color=darkred]
>I have a huge database and I'm calculating the number of days between four
> different date fields. (Field1 - field2); (field2 - field3); (field3 -
> field4)
>
> "Fred Taylor" wrote:
>
|
|
|
|