N() function

[Hidros]

N() is a google sheets function, what is the equivalent in appsheet?

I want to compare a column of [START time] (type TIME) with TIMENOW() function, but it doesn’t work.

In sheets I get it to work by getting the serial number of the [START time] with N() and that allows me the operations I need.

[Marc_Dillon]

Hidros:

N() is a google sheets function, what is the equivalent in appsheet?

https://support.google.com/docs/answer/3093357?hl=en

There is no exact equivalent. But you could try NUMBER() or, maybe EXTRACTNUMBERS()

Hidros:

I want to compare a column of [START time] (type TIME) with TIMENOW() function, but it doesn’t work.

How doesn’t it work? What exactly did you try?

Hidros:

the serial number of the [START time] with N()

What is a “serial number” of a Time value?

[Steve]

Hidros:

I want to compare a column of [START time] (type TIME) with TIMENOW() function, but it doesn’t work.

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

Hidros:

In sheets I get it to work by getting the serial number of the [START time] with N() and that allows me the operations I need.

Why??? Even in Sheets, that’s a complex solution to a simple problem. Times can be compared directly.