I have a table that has a date column in weweb tables. In wewebs documentation it says “If your table has date or date/time columns, the filter modal includes conditions designed for dates (for example “Is before”, “Is after”, “Is between”, and relative options like “Last 7 days” when available).
Use these for “Recent activity” style views.”
but none of these date filter options actually exist in any of the filters.
Can someone please help me with knowing how to filter dates like todays date, tomorrows date etc.
Also when creating wewebs date column there is a toggle for if the column should include time, I turned it off and the column still adds the time and when I select a date in the date picker when inserting a new row, it always adds the date before the date I choose and sometimes a random date I don’t know how it came up with.
Ah, sorry about this @Danny! It’s a mistake on our side: it was a feature that we planned for the release but didn’t get a chance to push to production yet. We’ll update the user docs.
In the meantime, this type of filtering with < and > operators should work for “is before”, “is after”, “is between” type of filters:
thank you so much for the reply and video, ive been up all night working on trying to figure it out. I literally about 5 minutes ago before your reply figured out another way I think by using a formula in a filter. For today it seems the date() operator works and for tomorrow the addDays(date(),1) is working. I can go to sleep now lol
one more quick thing, the only other issue im trying to solve is in a weweb table when I insert a new row and select the date, it always shows the date before the date I select regardless if I select today. I cant find any time zone setting and I tried the getBrowserTimezone operator thinking that might fix it but it shows the timezone im in (America/Chicago, CST). Im sure im doing something wrong
