Skip to main content

Hi,

I'm trying to apply a conditional layout on a column containing a “best before” date.
I hope to mark it red when the best_before < CAST(GETDATE() AS DATE) but CAST(GETDATE() AS DATE) obviously isn’t a constant…
When creating prefilters I can use a query but that doesn't seem to be an option for conditional layouts?

For now the only solution I can think of is adding an additional column (expression) that contains the beforementioned CAST(GETDATE() AS DATE) and use that column.
It works but I'm not 100% pleased with this workaround 🤔

Hi @Alban_T,

Indeed, the only current way to do this properly is by creating a (hidden) expression column that either say 1 or 0 based on the outcome of your query. The Conditional layout will then respond based on that number.

We do have an idea open about allowing a query as Conditional layout condition:

 

Terms & ConditionsCookie settings