とりあえず今年は「令和元年度」と印字して、2050年までは「令和漢字年」で
if
CurrentDate >= #2019/05/01#
and
CurrentDate <= #2019/12/31#
then
"令和元年度"
else
if
CurrentDate >= #2020/01/01#
and
CurrentDate <= #2050/01/01#
then
if instr("令和"+ towords(year(CurrentDate)) +"年度","一十")<> 0
then
replace(“令和”+ towords(year(CurrentDate)) +”年度”,”一十”,”十”)
else
“令和”+ towords(year(CurrentDate)) +”年度”
コメント