Filter data in XSLT-filter data accurate to the current time

Original, reprinted please indicate the source! Thank you!

In actual work, the customer requires that the information be filtered out at the specified time point. That is, if a piece of information is set to be published at, the data will not be filtered out before.

In fact, the requirement is very simple. Add a filtering condition in the designer to set the release time to be less than or equal to the current time. However, when using the designer + xslt, you will find that you can only select the current date, and the time selection function is not provided.

Later I studied the code generated by the system and found that it is actually a CAML query statement.

I tried it with the CAML tool and found that the time can be accurate.

 

So I think the time can also be selected in xslt. I replaced the query statement in xslt with the statement generated by the CAML tool.

The result is a failure and no data is found. It seems that xslt does not support "Now" usage. Later, I still use Today, but keep the IncludeTimeValue attribute. The result is successful! That is, the query statement of xslt is

Remember to replace all the symbols. Otherwise, an error will be reported in xslt.

Filter data in XSLT-filter data accurate to the current time