Timeline for In a Sharepoint list, can I format a date column by multiplying the date with a value in another column?
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 4 at 11:32 | history | edited | Rozemarijn Hoobroeckx | CC BY-SA 4.0 | added 166 characters in body |
| Mar 4 at 11:29 | vote | accept | Rozemarijn Hoobroeckx | ||
| Feb 25 at 16:20 | history | edited | Rozemarijn Hoobroeckx | CC BY-SA 4.0 | added 2284 characters in body |
| Feb 25 at 13:04 | comment | added | Rozemarijn Hoobroeckx | Thank you! Tried this first with the working code (without the mulitplication). That works fine. But unfortunately not with the multiplication in place. It seems there's something wrong with how I formulate this. | |
| Feb 20 at 4:05 | answer | added | Matiur Rahman | timeline score: 0 | |
| Feb 19 at 17:04 | comment | added | Rothrock | Might want to turn it around. All the other examples I've seen have the arithmetic on the other side of the comparator. @ currentField >= @ now - 604800000 | |
| Feb 19 at 13:01 | comment | added | Rozemarijn Hoobroeckx | @Rothrock Thank you for your swift answer. Unfortunately your suggestion did not work. One difference: In my code all dates went invisible. With the => the dates stayed black. But no yellow. If I remove "* @currentItem.testnummer" in my code, the fields turn yellow correctly (but without multiplied years). Thanks for the leap year warning. Good to know. Is not of importance in this list. | |
| Feb 18 at 15:30 | comment | added | Rothrock | This looks like it does the opposite of what you want, it colors it yellow until two years after the current date. If you change the <= around to >= I think that should work. It won't take into account leap years because there are a different number of ticks in a leap year. | |
| S Feb 18 at 14:44 | review | First questions | |||
| Feb 19 at 5:41 | |||||
| S Feb 18 at 14:44 | history | asked | Rozemarijn Hoobroeckx | CC BY-SA 4.0 |