Woohoo! Month(), Day(), Year() Now we just need hour, minute and second? [image]

[Screen Shot 2020-10-09 at 8.18.04 AM] It shouldn’t matter. I think it’s the math column bug and needs a refresh . Even when I just made this column right now, One of my other columns (a link column even?!) became visibly empty.

Same here, I still experienced this today.

@darder Could you share your app and tell me where you’re adding that column?

Thanks @Mark sending you a PM…

Is there a way to get the number of the day of the year? For instance today would be 31+24=55 the day(d) just returns a 24 for the day of the month.

@spencersRus [image] Find the last day of the following month Try this: FLOOR(275 * MONTH(date) / 9) - (FLOOR((MONTH(date) + 9) / 12) * (1 + FLOOR((YEAR(date) - 4 * FLOOR(YEAR(date) / 4) + 2) / 3))) + DAY(date) - 30 Don’t ask how it works, because I don’t know. Found …

It’s the gift that just keeps on giving :rofl: :rofl: :rofl:

I think it’s time to start organizing all of these formulas into an app. The list is growing!

🗓 Month, Day, and Year Math Functions

Ask for Help

Mark October 9, 2020, 7:48pm 29

This will be fixed on Thursday.

3 Likes

Can't Load Values from Month and Year formula on iOS

Topic		Replies	Views
🆕 Date-time Math General data-editor	126	14063	September 27, 2023
Fun with Dates Project Showcase	156	6937	April 19, 2022
Google sheets date functions in Glide Ask for Help	3	359	December 4, 2020
Nested expressions, less columns Ask for Help	21	1420	April 14, 2022
Thank you for date format plugin Project Showcase	5	498	July 8, 2022

🗓 Month, Day, and Year Math Functions

Related topics