# šŸ“… MORE Date Math incl. Weeknum! **URL:** \ **Category:** Ask for Help\ **Created:** [December 4, 2020, 3:33pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386 "2020-12-04T15:33:34Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 4, 2020, 3:33pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/1 "2020-12-04T15:33:34Z")
Huge win! Been asking for Weeknum for monthsā€”thanks @Mark and the rest of the Glide team! ![Item-0_and_Item-0_and_AppleBluetoothExtra](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d617bb0427e62c95e23f989bd43223b5252d045d.png) ---
**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\ **Post date:** [December 4, 2020, 4:11pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/2 "2020-12-04T16:11:07Z")
or, asking for many weeknumā€™s šŸ˜‰ ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 4, 2020, 4:16pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/3 "2020-12-04T16:16:42Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/58173497b41d90d9f6f3cb76868143e4e54e14bc.png) ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [December 4, 2020, 4:40pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/4 "2020-12-04T16:40:38Z")
I never understand why people use weeknumbers, to me itā€™s something for magazines and the like, i prefer dates! But if you like it Iā€™m happy for you! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 4, 2020, 4:42pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/5 "2020-12-04T16:42:28Z")
I donā€™t use it for display purposes. I use it for doing logic. Letā€™s say I want to have a weekly leaderboard that resets at the end of the week. I can combine the week number along with the current year to form an ID of sorts for the leaderboard. Then when the week changes, that ID changes and resets the leaderboard for the current week. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [December 4, 2020, 4:43pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/6 "2020-12-04T16:43:35Z")
ah, nice! ---
**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\ **Post date:** [December 4, 2020, 5:15pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/7 "2020-12-04T17:15:03Z")
Iā€™ve found it useful for payroll applications, dates in the same weeknum are summarized for employee hours ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [December 4, 2020, 5:21pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/8 "2020-12-04T17:21:07Z")
Thats huge!!! Butā€¦ am I the only curious about what youā€™re building with this delay column? šŸ™Š ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 4, 2020, 5:42pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/9 "2020-12-04T17:42:30Z")
No, thereā€™s no ā€œdelayā€ action or anythingā€”I was just making note that the visibility update of seconds is delayed about 10 seconds. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [December 4, 2020, 5:54pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/10 "2020-12-04T17:54:06Z")
Got itā€¦ Maybe I was expecting some time machine or something šŸ˜• ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [December 4, 2020, 5:55pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/11 "2020-12-04T17:55:58Z")
Thatā€™s great. Aiming to use this within a weekly planner tool I have on my ever expanding ā€˜to do listā€™ ---
**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\ **Post date:** [December 4, 2020, 8:35pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/12 "2020-12-04T20:35:33Z")
Genius use case šŸ‘ šŸ‘ ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [December 6, 2020, 12:31am UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/13 "2020-12-06T00:31:17Z")
Fantastic! Iā€™ve been doing these types of calcs in google sheets. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 22, 2021, 4:29pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/14 "2021-01-22T16:29:46Z")
@Robert_Petitto how did you calculate the Weeknum? I need to get it in an app Iā€™m doing ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 22, 2021, 4:36pm UTC](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386/15 "2021-01-22T16:36:05Z")
I didnā€™t know we had this function in Math columnā€¦ great! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/36284c7f1871aa85b3b6a2d2c4985b0aea8a1d2c.png)