# Date en direct **URL:** \ **Category:** Ask for Help\ **Created:** [May 24, 2024, 10:09pm UTC](https://community.glideapps.com/t/date-en-direct/73631 "2024-05-24T22:09:14Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Nino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nino/32/69878_2.png) [@Nino](https://community.glideapps.com/u/Nino)\ **Post date:** [May 24, 2024, 10:09pm UTC](https://community.glideapps.com/t/date-en-direct/73631/1 "2024-05-24T22:09:14Z")
Bonjour pouvez vous me dire comment avoir la dat et l’heure en direct svp ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 24, 2024, 11:59pm UTC](https://community.glideapps.com/t/date-en-direct/73631/2 "2024-05-24T23:59:46Z")
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? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 25, 2024, 7:14pm UTC](https://community.glideapps.com/t/date-en-direct/73631/3 "2024-05-25T19:14:52Z")
Bonjour Nino, bienvenue au forum de la communauté Glide 👋 Comme le suggère Thinh, 2 options au choix : 1. Une colonne math. Sélectionniez “Now”. 2. Une colonne template. Sélectionniez “Current time”. ![CleanShot 2024-05-25 at 21.09.28](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ff98b327d40683fd9a6e0f498c0e2fdaed500370.png) ![CleanShot 2024-05-25 at 21.11.27](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/3722d3e8290d5858720e45cfa53831bdd81d8797.png) Ces 2 options vous donneront la date et l’heure. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 25, 2024, 7:17pm UTC](https://community.glideapps.com/t/date-en-direct/73631/4 "2024-05-25T19:17:28Z")
@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. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 26, 2024, 12:20am UTC](https://community.glideapps.com/t/date-en-direct/73631/5 "2024-05-26T00:20:42Z")
> [@nathanaelb](#): > > In one column the settings is called “Now”, in the other “Current time”? Yeah, I would agree it’s inconsistent. > [@nathanaelb](#): > > 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? 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. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 26, 2024, 9:50pm UTC](https://community.glideapps.com/t/date-en-direct/73631/6 "2024-05-26T21:50:29Z")
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? ![Screenshot 2024-05-26 at 23.45.42](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/1607c7d68ea9a649cd83f87ed4bcdc09648d420f.png) ![Screenshot 2024-05-26 at 23.48.17](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d0f65c5870b602526585d23f907a2dbb7ab860bf.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 26, 2024, 10:24pm UTC](https://community.glideapps.com/t/date-en-direct/73631/7 "2024-05-26T22:24:28Z")
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. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 27, 2024, 9:07am UTC](https://community.glideapps.com/t/date-en-direct/73631/8 "2024-05-27T09:07:52Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 27, 2024, 12:49pm UTC](https://community.glideapps.com/t/date-en-direct/73631/9 "2024-05-27T12:49:46Z")
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? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 27, 2024, 12:54pm UTC](https://community.glideapps.com/t/date-en-direct/73631/10 "2024-05-27T12:54:07Z")
I now know now! ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [May 27, 2024, 1:01pm UTC](https://community.glideapps.com/t/date-en-direct/73631/11 "2024-05-27T13:01:57Z")
Is this what is known as expression? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 27, 2024, 1:46pm UTC](https://community.glideapps.com/t/date-en-direct/73631/12 "2024-05-27T13:46:51Z")
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. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/440f14e9001c184b33504688a16e28eacb8fe88a.jpeg "Indonesian is not confusing at all") ](https://www.youtube.com/watch?v=h3ijB91ZYJY) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [May 27, 2024, 1:55pm UTC](https://community.glideapps.com/t/date-en-direct/73631/13 "2024-05-27T13:55:21Z")
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).