>= giving odd results

[1minManager]

[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

[SkrOYC · Accepted solution]

The result is duration.
Try wraping with DAY() and then the <>= 90

Edit: Sorry, with HOUR() and then /24 to get the days

help.appsheet.com

HOUR()

Hour of day from Duration

Edit 2: Just in case it’s not clear enough:

(HOUR(
  TODAY()-DATE([JobCreation])
)/24)>=90

[Aurelien]

@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"

[SkrOYC]

Aurelien:

The notions of TIME and DURATION and how to use in expressions

Didn’t know that post existed.
That’s a good one from @KJS

[1minManager]

Sorry guys, Friday brain fade Formula for jobs older than 90day should be

TODAY()>=[JobCreation]+90 

Big thanks to @SkrOYC and @Aurelien for explaining