FOXPRO - 如何计算被保险人的持续时间（* .DBF） [英] FOXPRO - how to calculate the duration of an insured person ( *.DBF)
问题描述
大家好！
我对被保险人的时间有问题（数据库：FOXPRO）示例：
表1：
Hi All !
I have a problem about the time the insured (database: FOXPRO) example:
Table1:
fullname | begindate | enddate | printdate
-----------------------------------------------------
John | 01/10/2013 | 30/09/2014 | 28/09/2013
John | 01/12/2015 | 30/09/2016 | 28/11/2015
Mery | 01/01/2010 | 31/12/2012 | 27/05/2011
Mery | 01/01/2013 | 30/12/2013 | 29/12/2012
Tom | 01/01/2010 | 31/12/2012 | 27/05/2011
Tom | 01/09/2012 | 30/12/2013 | 29/08/2012
-----------------------------------------------------
如何把时间常数放在新桌子上
恒定的时间，John，Mery，Tom的间歇时间？
谢谢！
我的尝试：
字段：Begindate - >保险开始日期
字段：Enddate - >结束日期投保
这意味着：每人每年都会获得一次性卡，计算时间常数，并且自订婚以来间歇性地计算结束。
Exp：
how to put the time constant on the new table
constant time,intermittent time of John, Mery, Tom ?
Thanks !
What I have tried:
Fields: Begindate -> Start date insured
Fields: Enddate -> End date insured
This mean: per person per year are granted a one-time card, calculate the time constant and intermittently since engaged until the end.
Exp:
John
+ insured: {01/10/2013-30/09/2014} (first year)= 12 month
- not engaged: {01/10/2014-30/11/2015} = 14 month
+ insured: {01/12/2015-30/09/2016} (last year) = 10 month
-> no ongoing involvement
----------------------------------------
Mery
+ insured: {01/01/2010 - 31/12/2012} (first year)= 36 month
+ insured: {01/01/2013 - 30/12/2013} (last year) = 12 month
-> ongoing involvement = 36 + 12 = 48 month
----------------------------------------
Tom
+ insured: {01/01/2010-31/12/2012} (first year)= 36 month
+ insured: {01/09/2012-30/12/2013} (last year) = 16 month
-> ongoing involvement = 36 + 12 = 48 month (not=36+16)
----------------------------------------
我想将所有结果显示给其他.DBF文件
我不知道如何在FoxPro中编写命令？
我尝试使用数组来计算结果但不是，我们正在寻找代码的帮助。非常感谢！
I want to show all the results to other .DBF file
I don't know how to write the command in FoxPro ?
I tried using the array to calculate given the results but is not, we're looking for help for code. Thanks a lot !
推荐答案
字段：Begindate - >保险开始日期
字段：Enddate - >保证结束日期
Fields: Begindate -> Start date insured
Fields: Enddate -> End date insured
This mean: per person per year are granted a one-time card, calculate the time constant and intermittently since engaged until the end.
Exp:
John
+ insured: {01/10/2013-30/09/2014} (first year)= 12 month
- not engaged: {01/10/2014-30/11/2015} = 14 month
+ insured: {01/12/2015-30/09/2016} (last year) = 10 month
-> no ongoing involvement
----------------------------------------
Mery
+ insured: {01/01/2010 - 31/12/2012} (first year)= 36 month
+ insured: {01/01/2013 - 30/12/2013} (last year) = 12 month
-> ongoing involvement = 36 + 12 = 48 month
----------------------------------------
Tom
+ insured: {01/01/2010-31/12/2012} (first year)= 36 month
+ insured: {01/09/2012-30/12/2013} (last year) = 16 month
-> ongoing involvement = 36 + 12 = 48 month (not=36+16)
----------------------------------------
I want to show all the results to other .DBF file
I don't know how to write the command in FoxPro ?
Thanks a lot !
这篇关于FOXPRO - 如何计算被保险人的持续时间（* .DBF）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
