数式でテキストを日付フォーマットに変換します

1. 使用シーン

この例では、適切な式でテキストを日付形式に変換する方法を学びます。

2.機能を実現する

2.1構成表ページ

2.2フィールド式の設定

実際のニーズに合わせてフィールドを変更することに注意してください。

(1) 日時 (年月日)

{"text":"TIMESTAMP(DATE(MID(​文本时间​,1,4),MID(​文本时间​,5,2),MID(​文本时间​,7,2)))","marks":[{"from":{"line":0,"ch":19,"sticky":null},"to":{"line":0,"ch":25,"sticky":null},"value":"textField_ksh9bz3r","invalid":false},{"from":{"line":0,"ch":35,"sticky":null},"to":{"line":0,"ch":41,"sticky":null},"value":"textField_ksh9bz3r","invalid":false},{"from":{"line":0,"ch":51,"sticky":null},"to":{"line":0,"ch":57,"sticky":null},"value":"textField_ksh9bz3r","invalid":false}],"isCmData":true}

(2) 日時 (年月日時分秒)

{"text":"TIMESTAMP(DATE(MID(​文本时间​,1,4),MID(​文本时间​,5,2),MID(​文本时间​,7,2),MID(​文本时间​,9,2),MID(​文本时间​,11,2),MID(​文本时间​,13,2)))","marks":[{"from":{"line":0,"ch":19,"sticky":null},"to":{"line":0,"ch":25,"sticky":null},"value":"textField_ksh9bz3r","invalid":false},{"from":{"line":0,"ch":35,"sticky":null},"to":{"line":0,"ch":41,"sticky":null},"value":"textField_ksh9bz3r","invalid":false},{"from":{"line":0,"ch":51,"sticky":null},"to":{"line":0,"ch":57,"sticky":null},"value":"textField_ksh9bz3r","invalid":false},{"from":{"line":0,"ch":67,"sticky":null},"to":{"line":0,"ch":73,"sticky":null},"value":"textField_ksh9bz3r","invalid":false},{"from":{"line":0,"ch":83,"sticky":null},"to":{"line":0,"ch":89,"sticky":null},"value":"textField_ksh9bz3r","invalid":false},{"from":{"line":0,"ch":100,"sticky":null},"to":{"line":0,"ch":106,"sticky":null},"value":"textField_ksh9bz3r","invalid":false}],"isCmData":true}