📅 MORE Date Math incl. Weeknum!

[Robert_Petitto]

Huge win! Been asking for Weeknum for months—thanks @Mark and the rest of the Glide team!

[Cisco_Muratalla]

or, asking for many weeknum’s

[Robert_Petitto]

[erwblo]

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!

[Robert_Petitto]

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.

[erwblo]

ah, nice!

[Cisco_Muratalla]

I’ve found it useful for payroll applications, dates in the same weeknum are summarized for employee hours

[Lucas_Pires]

Thats huge!!!

But… am I the only curious about what you’re building with this delay column?

[Robert_Petitto]

No, there’s no “delay” action or anything—I was just making note that the visibility update of seconds is delayed about 10 seconds.

[Lucas_Pires]

Got it…

Maybe I was expecting some time machine or something

[Rosewebstudio]

That’s great.

Aiming to use this within a weekly planner tool I have on my ever expanding ‘to do list’

[Pablo_books]

Genius use case

[Errcomp]

Fantastic! I’ve been doing these types of calcs in google sheets.

[Lucas_Pires]

@Robert_Petitto how did you calculate the Weeknum? I need to get it in an app I’m doing

[Lucas_Pires]

I didn’t know we had this function in Math column… great!