[{"id":"840f0737-df1d-47ae-bb0a-359b01fe0608","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"d5d9cdef-8854-4505-89be-a2bbc3cb4482","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"3dc3dd55-35b0-4d23-bf62-47bc3650e4ee","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"80d84fbc-d0f8-4e4a-947f-e3e4de9b49b2","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"9152b7ca-0186-4fe3-a26f-5a05f322db07","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]}]
        
(Showing Draft Content)

Now/Today/Year/Quarter/Month/Day函数示例-获取年季度月日

取当前日期(时间部分为0:00:00): {Today()}

取当前时间(含日期和时间): {Now()}

取当前年度: {Year(Today())}

取当前月份: {Month(Today())}

取当月首日: {DateSerial(Year(Today()),Month(Today()),1) }

取当月末日(原理是:当月首日先加一个月,成为次月首日,再减一天,即为当月末日): {DateAdd("d",-1,DateAdd("m",1,DateSerial(Year(Today()),Month(Today()),1)))}

示例

比如今天是2020年10月13日,我们以获取今天的年、季度、月、日为例进行介绍。

image2020-10-13_9-25-35.png

如将表达式中的“ today() ”换成具体字段,即可获取到字段值的年、季度、月、日。

比如使用表达式 {Month(订购日期)} 获取订购日期字段第一个日期的月份值。