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 🤔
Solved
conditional layout check on a date
- Captain
- 79 replies
Best answer by Mark Jongeling
Hi
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:
This topic has been closed for comments
+23Hi
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.