查询Col1>今天() [英] Query Col1 > today()

问题描述

当我使用下面留下的格式时，返回错误，我知道相对于WHERE AND，缺少某些调整...但是我不适合提供此错误.

When I use the format that I left below, returns in error, I know that something is missing adjusting in relation to WHERE AND... But I could not fit to supply the error.

我想知道我错过了什么.

I would like some help knowing what I missed.

"select Col1,Col2,Col3 where Col1 is not null Order by Col1, Col2 AND Col1 > date'"&TEXT(today()-1,"yyyy/mm/dd")&"'"

Col1和Col2的日期和时间是这样的:

The date and time for Col1 and Col2 are like this:

我希望借助此公式，我只能过滤那些具有当天或明天日期并且今天的游戏时间高于当前时间的数据.

With this formula, I hope I can filter the imported data only for those that have the date of the current day or tomorrow and that today's games are higher than the current time.

链接到电子表格: https://docs.google.com/spreadsheets/d/15T4DAPOUB edit?usp = sharing

在Página1G2中设置的公式

Formula set in Página1 G2

推荐答案

看起来您可以根据需要组合参数，但是需要遵循特定的顺序:

it may look like you can combine parameters as you like but there is a specific order that needs to be followed:

分别像and这样的联接运算符需要由父参数where进行处理:

respectively joining operator like and needs to be proceeded by parent parameter where:

这篇关于查询Col1>今天()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！