I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. [image] Find the last day of the following month …

[image] Jeff_Hager: What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of text and it will …

Here you go. Just use 1.5 years for the number of years, or you can take your number of months and divide by 12. Same thing either way. [image] Glide Editor screen goes blank when using Math Column Report a Bug Edit: I have some updates to this formula that I’ve explain…

Quick Q - can’t think… :thinking: Using 'glide tables’ I need to calculate the day from a date so ‘NOW’ = ‘Wednesday’ (in the uk)

Day(NOW) will give you the day (number) of the week, then plug that into an ITE

Used this in a recent app for a client — check it out:

Makes sense, I think ‘Now’ is always going to be ‘Now’ :slightly_smiling_face:

I solved it—had to use a math column to convert the text to a date and then pass the math column instead: [Screen Shot 2021-02-10 at 10.47.46 AM] [Screen Shot 2021-02-10 at 10.48.35 AM]

This is awesome. I can make completed task to be removed after a few months. Or I can do reminders for uncompleted task. Idea is on creating a task, a static date would be inputed. month from now, and in a second col. If today is past then show red color. Need to think. Anyway Will need to test this…

That’s weird. I had assumed that once the text is placed into a date column, it’s then converted to a date and becomes static. So you’re saying that the text version is still buried somewhere in that date column, which makes it dynamic? I’ll have to play around with that some more. I have some i…

Fun with Dates

Project Showcase

Robert_Petitto February 10, 2021, 3:38pm 81

@Jeff_Hager perhaps a flaw here?

How to connect an hour with a date?

Topic		Replies	Views
Find the last day of the following month Ask for Help holdmybeer	47	3292	January 17, 2024
🆕 Date-time Math General data-editor	126	14075	September 27, 2023
📅 Guide on Dates & Times Community Resources	22	1671	April 2, 2025
If then else with DATE Ask for Help	28	3302	May 25, 2022
🗓 Month, Day, and Year Math Functions Ask for Help	47	3859	July 15, 2023

Fun with Dates

Related topics