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

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

Thanks @Mark sending you a PM…

This will be fixed on Thursday.

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!

Is there a function to get the name of the month from a date? I can do it in google sheets but would be cleaner if I could add a column in glide data.

[image] Food2Soil: Is there a function to get the name of the month from a date? [image]

cccc gives me weekday. whats the format for month name. is there a list somewhere of all available formats. thanks much!

🗓 Month, Day, and Year Math Functions

Ask for Help

Jeff_Hager February 24, 2021, 4:11pm 31

@spencersRus

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

🗓 Month, Day, and Year Math Functions

Related topics