自己用一个小程序就好了
if month(x1)<10 and day(x1)<10 then x=compress(year(x1)||"0"||month(x1)||"0"||day(x1));
else if month(x1)>=10 and day(x1)<10 then x=compress(year(x1)||month(x1)||"0"||day(x1));
else if month(x1)<10 and day(x1)>=10 then x=compress(year(x1)||"0"||month(x1)||day(x1));
else x=compress(year(x1)||month(x1)||day(x1));
至于变量名,delete原来的X1,对新变量rename一下就好了