siyuan-note / siyuan

A privacy-first, self-hosted, fully open source personal knowledge management software, written in typescript and golang.
https://b3log.org/siyuan
GNU Affero General Public License v3.0
18.52k stars 1.38k forks source link

数据库日期筛选的问题 #12546

Closed Jiangshuon closed 2 hours ago

Jiangshuon commented 4 hours ago

Is there an existing issue for this?

Can the issue be reproduced with the default theme (daylight/midnight)?

Could the issue be due to extensions?

Describe the problem

筛选当前周和前一周没有问题,前2周就有问题了

image

image

image

Expected result

。。

Screenshot or screen recording presentation

No response

Version environment

- Version: 最新
- Operating System: win11
- Browser (if used):

Log file

。。

More information

No response

88250 commented 2 hours ago

你好,我没有看出问题,请具体描述一下。

Jiangshuon commented 2 hours ago

9月2号不是前两周的吧

88250 commented 2 hours ago

9月2号是前两周的周一:

image

Jiangshuon commented 2 hours ago

哦哦,前两周是这个意思。

那我想筛选出上上周(7天)的数据,怎么填呢

我用"介于”好像不行

image

88250 commented 2 hours ago

创建时间、更新时间 字段的 介于 计算确实有问题,稍后修复。

请等发布下一个 dev 版时帮忙测试看看,谢谢。