【结】自动填充里面数据类型转换

liyuting730

IIf(结束日期 is not null,YearOf(结束日期)||IIf(Length(MonthOf(结束日期))=1,0||MonthOf(结束日期),MonthOf(结束日期)),
IIf(预算年月 IS NOT NULL,YearOf(IncMonth(CAST(SubString(预算年月,1,4)||'-'||SubString(预算年月,5,2)||'-01' AS DATE),-2))||IIf(Length(MonthOf(IncMonth(CAST(预算年月 AS DATE),-2)))=1,0||MonthOf(IncMonth(CAST(SubString(预算年月,1,4)||'-'||SubString(预算年月,5,2)||'-01' AS DATE),-2)),MonthOf(IncMonth(CAST(SubString(预算年月,1,4)||'-'||SubString(预算年月,5,2)||'-01' AS DATE),-2))),NULL))


如：201011变成 201101

改来改去还是没有实现，请问怎么把数字转换成字符串格式的？
我想通过加月份的方式改，也可以通过加2然后判断是否大于12再计算，但是，如果通过转换成日期怎么做？

liyuting730

成功了，结贴吧。。。
虽然很复杂，好像没有必要，但是还是解决了。
有人有兴趣帮忙简化一下，就多谢了！

IIf(结束日期 is not null,YearOf(结束日期)||IIf(Length(MonthOf(结束日期))=1,0||MonthOf(结束日期),MonthOf(结束日期)),
IIf(预算年月 IS NOT NULL,YearOf(IncMonth(CAST(SubString(cast(预算年月 as char),1,4)||'-'||SubString(cast(预算年月 as char),5,2)||'-01' AS DATE),-2))||IIf(Length(MonthOf(IncMonth(CAST(cast(预算年月 as char) AS DATE),-2)))=1,0||MonthOf(IncMonth(CAST(SubString(cast(预算年月 as char),1,4)||'-'||SubString(cast(预算年月 as char),5,2)||'-01' AS DATE),-2)),MonthOf(IncMonth(CAST(SubString(cast(预算年月 as char),1,4)||'-'||SubString(cast(预算年月 as char),5,2)||'-01' AS DATE),-2))),NULL))