Using date('now') in a filter or in conditional formatting? #4107
-
|
Hello folks, I'm really enjoying the software! I wonder if there's a way to use expressions like date() in filters or conditional formatting to do something like "everything before today" or "within the next week". I have tried a few variations but they don't seem to do it. Thanks in advance for any insight or suggestions! |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 3 replies
-
|
how have you got your dates? yyyy-MM-dd format? |
Beta Was this translation helpful? Give feedback.
-
|
That's right, ISO dates ftw 👍 |
Beta Was this translation helpful? Give feedback.
-
|
Well done ... slap on the back for you!! |
Beta Was this translation helpful? Give feedback.
-
|
Thanks. My vote for an item on the backlog (probably the wrong place for it) would be date() evaluation in conditional formatting. And while I'm suggesting, currency formatting (and/or formatting with a thousands separator) in browse would be nice too. These are small items though in a great, lightweight, and highly functional piece of software. Let me know if I should paste my suggestions over in "Ideas" rather than here. Thanks again! |
Beta Was this translation helpful? Give feedback.
Well done ... slap on the back for you!!
That does mean the usual text sorting will work, so > '2026-01-01' for this year, or < '2026-03-01' for before March, etc.
So not a generic 'before today' but you can do < '2026-03-10'