How do you use the "today" item

Ask for Help
1

Is this a glitch or am I just using this wrong?

Screen Shot 2022-06-15 at 10.50.21 PM
Screen Shot 2022-06-15 at 10.50.21 PM1358×898 73.8 KB

The date is after today, why isn’t it outputting true?

2

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

3

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
Screen Shot 2022-06-15 at 11.21.34 PM1172×844 44.7 KB

4

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

5

What would the correct format/configuration be? I tried almost everyone.

6

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?

7

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 “after”

Working with dates and times in Glide can get very tricky.

8

" 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

9

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.

10

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

11

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. Something like this:

Year(Now) * 10000 + Month(Now) * 100 + Day(Now)

This will give you something like 20220616, which can be used to do a direct numerical comparison.

2 Likes
12

That sounds great, how would I convert a date into an integer to do the comparison though?

13

Just use the same formula, and use the Date as a replacement instead of Now.

3 Likes
14

Darren you did it again, what a legend man aha

15

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

4 Likes
17

Bob needs a fun name…

1 Like
18

hehe, yes he does. Will give that some thought… :wink:

1 Like
19

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.