Date en direct

Bonjour pouvez vous me dire comment avoir la dat et l’heure en direct svp

In any form environments, you would find a “current date/time” value that you can set to a column in the destination table.

You can also reference “now” in math columns, or “current time” in various other columns.

Can you describe more about your use case?

Bonjour Nino, bienvenue au forum de la communauté Glide :wave:

Comme le suggère Thinh, 2 options au choix :

  1. Une colonne math. Sélectionniez “Now”.
  2. Une colonne template. Sélectionniez “Current time”.

Ces 2 options vous donneront la date et l’heure.

@ThinhDinh
Do you know why:

  1. In one column the settings is called “Now”, in the other “Current time”?
  2. When comparing the two columns in an IFE column, the values seem to be different, even though visually they look the same. Would this be because the column types are different, or because the values are actually different?

If you don’t know no worries, I’m just curious.

Yeah, I would agree it’s inconsistent.

Visually, some columns “prettify” the value for you. In the if-then-else column, if all “results” are not using the same type, they tend to return the dates in their original format, as I understand. I don’t remember if it keeps the format if all your results are in the same date/time format.

I didn’t express myself correctly. An image will explain what I meant more clearly. I wonder why the IFE says these two columns are different. Based on how I configured the ITE column, I would have expected the checkbox to be checked. Because their type is different? Or truly under the hood the two values are different?

When you add a date into a template column, the underlying value of the date no longer applies as the value of the template column is just the formatted version of the date (a text data type). The value of the math column still has the underlying date which can include milliseconds. What you see as the formatted value of a date is not what the true underlying value is.

Basically you are correct that you are comparing apples to oranges and you are evaluating two different data types. But those different data types also mean that the values being compared are completely different.

001 doesn’t necessary equal 1 in some cases.

Hope that kind of makes sense.

3 Likes

Yes that totally makes sense. Although I know in theory the template column acts this way, I had never done the comparison on the Now value and was actually surprised the values were different. I guess I shouldn’t have.

So it seems the columns behave as follows:

Now → (Math column) → Now where Now is a timestamp value (probably an integer or an ISO date and time format under the hood)

Now → (Template column) → Now’ where Now’ is a text value that appears to be Now but is not Now.

This is starting to feel like deja vu, I think I might have done this years ago and simply forgot about it.

Now there, I know you get it now. Knowing now means you know what you need to know now. I now know you know how to use now. So, focus on knowing now and always be in the know now. You know?

3 Likes

I now know now!

2 Likes

Is this what is known as expression?

Maybe not so much an expression, but more of an example of how English can be confusing with spelling or pronunciation of words that don’t follow consistent rules, or words that can have multiple meanings.

Know and Now is probably a bad example since they are both spelled and pronounced differently, but they are very similar.

I know English isn’t your native language, but I think this is a very close example of what I mean.

3 Likes

I roughly know what you mean. In addition, the word expression also has two meanings. One that comes from the mind (such as: Sign), and one that is close to a formula.
Everything is within the cultural consensus (says U. Eco).

2 Likes