魔方网表 让信息化更简单

 找回密码
 注册
查看: 3793|回复: 1

[原创] 如何实现把数字日期格式转中文日期格式?

[复制链接]
fade01 发表于 2019-2-27 10:32:12 | 显示全部楼层 |阅读模式
表中我们建立一个字段名为“日期”字段类型为日期的字段,在创建一个字段名为“文字日期”文本类型字段。在“文字日期”这个字段属性中设置公式,
公式如下:
CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),1,1)+1,"○","一","二","三","四","五","六","七","八","九")&CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),2,1)+1,"○","一","二","三","四","五","六","七","八","九")&CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),3,1)+1,"○","一","二","三","四","五","六","七","八","九")&CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),4,1)+1,"○","一","二","三","四","五","六","七","八","九")&"年"&CHOOSE(TEXT($MF(日期)$,"MM")+0,"一","二","三","四","五","六","七","八","九","十","十一","十二")&"月"&IF(TEXT($MF(日期)$,"dd")+0 < 16,CHOOSE(TEXT($MF(日期)$,"dd")+0,"一","二","三","四","五","六","七","八","九","十","十一","十二","十三","十四","十五"),CHOOSE(TEXT($MF(日期)$,"dd")-15,"十六","十七","十八","十九","二十","二十一","二十二","二十三","二十四","二十五","二十六","二十七","二十八","二十九","三十","三十一"))&"日"
$MF(日期)$指数字日期字段,可以在一个文本字段中启用上述公式存储转换后的中文日期。
函数什么用法可以在选择的时候看一下介绍。
8.png
程寒素 发表于 2021-1-10 22:34:24 | 显示全部楼层
:'(:shutup::handshake
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则


Archiver|手机版|小黑屋|魔方软件 ( 京ICP备08008787号 )

京公网安备 11010702001722号

GMT+8, 2024-5-19 22:00 , Processed in 0.060875 second(s), 19 queries .

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

快速回复 返回顶部 返回列表