Is this a glitch or am I just using this wrong? [Screen Shot 2022-06-15 at 10.50.21 PM] The date is after today, why isn’t it outputting true?

[image] moshi: That seems like a good idea, thank you for that. The issue is for this app it’s crucial that the comparison has to be for the current day. If you want to eliminate the possibility that the time gets in the way, you can use a math column to convert the date to an integer. Someth…

you are probably using a different format than indicated, how did you get the date in your pickup_date column?

[image] JuanM: pickup_date column? Here is the format. I tried almost every configuration. Not sure why it’s doing this [Screen Shot 2022-06-15 at 11.21.34 PM]

you are probably using a different format than indicated, how did you get the date in your pickup_date column?

What would the correct format/configuration be? I tried almost everyone. [image] moshi: Here is the format. I tried almost every configuration. Not sure why it’s doing this [Screen Shot 2022-06-15 at 11.21.34 PM]

I’m considering creating a template column where I replace the variable with the NOW function, then just compare those two columns instead, but I feel like that’s a dirt way of doing it. Shouldn’t the TODAY function suffice?

One thing to be aware of is that regardless of which display format you choose, under the hood Glide still stores the full date AND time. You can see that value if you click in the cell. So possibly that’s whats tripping things up here. A simple fix might be to use “on or after” instead of just “a…

" 2022-06-15T22:31:11.314Z " this is the correct format in glide, are you manually typing the date in your column? If the answer is yes, copy this format without quotes or spaces and paste them in your column to test

[image] Darren_Murphy: A simple fix might be to use “on or after” instead of just “after” That seems like a good idea, thank you for that. The issue is for this app it’s crucial that the comparison has to be for the current day.

The user is not submitting the date manually, they are picking from a calendar.

[image] Darren_Murphy: Year(Now) * 10000 + Month(Now) * 100 + Day(Now) That sounds great, how would I convert a date into an integer to do the comparison though?

How do you use the "today" item

Ask for Help

Darren_Murphy June 16, 2022, 3:51am 15

hehe, I only know all this stuff because I pay attention to what guys like Chuck, Bob and Sly say

Topic		Replies	Views
Glide table issue with "today" function Ask for Help	7	1592	July 29, 2022
🆕 Comparing Dates General	51	4526	January 14, 2022
Time Comparisons Ask for Help	13	1267	February 15, 2022
Button to Appear only if Date = Today Ask for Help	10	938	November 20, 2021
Current date and time Ask for Help	18	1442	June 28, 2023

How do you use the "today" item

Related topics