Question

VFP如何分别获取表中日期字段的年月日

数据库中有一张表，表中有个字段rkrq,添加的记录比如说为08/04/15,如何在表单中如下图呈现

Answer 1

set date to ansi
a1=str(year(rkrq),4,0)
a2=dtoc(rkrq)
a3=subs(a2,4,2)
a4=subs(a2,7,2)
THISFORM.Text1.Value=a1
THISFORM.Text1.Value=a3
THISFORM.Text1.Value=a4

Answer 2

thisform.text1.value=year(rkrq)
thisform.text2.value=moth(rkrq)
thisform.text3.value=day(rkrq)

追问

use rkdwj.dbf
thisform.text1.value=year(rkrq)
thisform.refresh
我这样写了代码，木有反应T.T