# Filter table component using a date (surely there is a way!) **URL:** \ **Category:** Ask for Help\ **Created:** [March 12, 2026, 12:50am UTC](https://community.glideapps.com/t/filter-table-component-using-a-date-surely-there-is-a-way/86641 "2026-03-12T00:50:44Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\ **Post date:** [March 12, 2026, 12:50am UTC](https://community.glideapps.com/t/filter-table-component-using-a-date-surely-there-is-a-way/86641/1 "2026-03-12T00:50:44Z")
I have a table component that displays data that has a date column. I want to add a filter that uses this date column. ![Screenshot 2026-03-12 at 11.48.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d5c7e7f8de2d2cee10c4cf4bbcb5dc6f83e99a93.png) Instead of ‘today’ I want to use the first day of this quarter. In my case, 1 Jan 2026. I can calculate 1 Jan 2026 using a JavaScript column, however this JS column available as an option to replace ‘today’. I don’t really mind how I achieve this, but I want to filter rows that are before and after the start of the current quarter. There is no other col in my data that indicates which date this is. ---
**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:** [March 12, 2026, 3:40am UTC](https://community.glideapps.com/t/filter-table-component-using-a-date-surely-there-is-a-way/86641/2 "2026-03-12T03:40:22Z")
Javascript always returns a text string type. You will never get a date type returned from a javascript column. If you want to be able to filter by a date, you will either need a basic date column in the same table or the user table, or a math column to dynamically calculate the date from an existing date, such as now/today. ---
**Author:** ![Federico\_Fleitas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/federico_fleitas/32/77461_2.png) [@Federico\_Fleitas](https://community.glideapps.com/u/Federico_Fleitas)\ **Post date:** [March 12, 2026, 11:24am UTC](https://community.glideapps.com/t/filter-table-component-using-a-date-surely-there-is-a-way/86641/3 "2026-03-12T11:24:41Z")
Hi, You can use this formula with your date colum. Attached Formula: year(today)\*10000 + month(today)\*100 + day(today) ---
**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:** [March 13, 2026, 2:16am UTC](https://community.glideapps.com/t/filter-table-component-using-a-date-surely-there-is-a-way/86641/4 "2026-03-13T02:16:43Z")
![CleanShot 2026-03-13 at 09.16.24](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c1b2ad2423392b98d80ca7bef4efd095a362605a.png) You can try my math formula. ```auto D - DAY(D) + 1 - (MIN(MOD(MONTH(D) - 1, 3), 1) * DAY(D - DAY(D))) - (MAX(MOD(MONTH(D) - 1, 3) - 1, 0) * DAY(D - DAY(D) - DAY(D - DAY(D)))) ``` ---
**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:** [March 13, 2026, 8:36am UTC](https://community.glideapps.com/t/filter-table-component-using-a-date-surely-there-is-a-way/86641/5 "2026-03-13T08:36:42Z")
That’s a magic one! 🧙 May I add your formula to the date guide? @ThinhDinh ---
**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:** [March 13, 2026, 12:25pm UTC](https://community.glideapps.com/t/filter-table-component-using-a-date-surely-there-is-a-way/86641/6 "2026-03-13T12:25:15Z")
Feels like I’m doing a bit of a disservice not explaining the idea in full, so here it is. > **[Drop HTML - LowCode Agency](https://view.lowc.dev/r6W-Tfw_3X)** > > Share HTML snippets with a simple link Sorry it’s too big so I have to upload it elsewhere. ---
**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\ **Post date:** [March 17, 2026, 3:38am UTC](https://community.glideapps.com/t/filter-table-component-using-a-date-surely-there-is-a-way/86641/7 "2026-03-17T03:38:03Z")
thanks everyone, I ended up needing to transform some of the data before adding rows to Glide. In the process I used Google App Script to add a current/previous column to the csv before it gets to Glide which negates the need for calculations in Glide in my current set up 🙂 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 24, 2026, 3:38am UTC](https://community.glideapps.com/t/filter-table-component-using-a-date-surely-there-is-a-way/86641/8 "2026-03-24T03:38:39Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.