英文:
Unable to parse query string for Function QUERY parameter 2: Invalid date literal [$C6]. Date literals should be of form yyyy-MM-dd
问题
你好，问题出在哪里
无法解析函数QUERY参数2的查询字符串：无效的日期文本[Sheet2!C6]。日期文本应该是yyyy-MM-dd的形式。
=QUERY(Sheet1!A2:P, "select count(M) where B=date 'Sheet2!C6' ")
我尝试创建日期过滤器
我不知道为什么参数"Sheet2!C6"不起作用！！？
英文:
Hello where is the problem
Unable to parse query string for Function QUERY parameter 2: Invalid date literal [Sheet2!C6]. Date literals should be of form yyyy-MM-dd.
=QUERY(Sheet1!A2:P, "select count(M) where B=date 'Sheet2!C6' ")
i'm try to create filtre date
I don't why is param "Sheet2!C6" not working !!??
答案1
得分: 1
*You may try:*
=query(Sheet1!A2:P, "select count(M) where B=date'"&text(Sheet2!C6,"yyyy-mm-dd")&"'")
**OR**
=counta(ifna(filter(Sheet1!M2:M,Sheet1!B2:B=Sheet2!C6)))
英文:
<!-- language-all: js -->
You may try:
=query(Sheet1!A2:P, "select count(M) where B=date'"&text(Sheet2!C6,"yyyy-mm-dd")&"'")
OR
=counta(ifna(filter(Sheet1!M2:M,Sheet1!B2:B=Sheet2!C6)))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论