[JobCreation] is a DateTime column. Iโm trying to create a forumula for a slice.
TODAY()-DATE([JobCreation])=90
Works fine. As does <>. But what I really want is:
TODAY()-DATE([JobCreation])>=90
But this errors with
Arithmetic expression โ((TODAY()-DATE([JobCreation])) >= 90)โ does not have valid input types
As does every other combination such as >, <, =< and <=. With the exception of => which errors with:
Expression โTODAY()-DATE([JobCreation])=>90โ could not be parsed due to exception: The given key was not present in the dictionaryโฆ
Brackets such as
(TODAY()-DATE([JobCreation]))>=90
makes no difference to the error
Canโt work out what Iโm doing wrong
Solved! Go to Solution.
The result is duration.
Try wraping with DAY()
and then the <>= 90
Edit: Sorry, with HOUR()
and then /24 to get the days
Edit 2: Just in case itโs not clear enough:
(HOUR(
TODAY()-DATE([JobCreation])
)/24)>=90
The result is duration.
Try wraping with DAY()
and then the <>= 90
Edit: Sorry, with HOUR()
and then /24 to get the days
Edit 2: Just in case itโs not clear enough:
(HOUR(
TODAY()-DATE([JobCreation])
)/24)>=90
@SkrOYC good tip !
@1minManager The notions of TIME and DURATION and how to use in expressions
Alternatively, you can also use the following format: โ00.00:00:00โ, here you begin with 2 digits then a dot then 2 digits: 00.00 , this corresponds to days.hours:minutes:seconds.
TODAY()-DATE([JobCreation])>="90.00:00:00"
Didnโt know that post existed.
Thatโs a good one from @KJS
User | Count |
---|---|
37 | |
25 | |
21 | |
20 | |
16 |