I was wondering if it is possible, directly in Glide (without using sheet), to calculate the last calendar day of the month following the current one. For example: today is January 22, the date I need is February 28, 2021. This is useful for some payment installments in commercial contracts. Than…

[image] Jeff_Hager: ((Now-DAY(Now)+15)+60) - DAY((Now-DAY(Now)+15)+60) So, I’ll explain the logic a little bit. My main goal was to try to get the 1st day of the month, but two months from now. So for example, today is January 22nd. My goal was to figure out March 1st, and then simply subt…

ooooh, I can’t wait to see what @Jeff_Hager comes up with for this one :laughing: :rofl:

I’ve figured out a brute force approach that I believe will work. I’ll post it once I’ve had a chance to test and validate it.

Okay, I have a “solution”. And it ONLY requires 40 math columns and 3 if-then-else columns :rofl: :rofl: So no, please don’t take this as a serious suggestion. I just enjoy a challenge :laughing: ▶ My approach... ▶ Step by step... Voila! [Screen Shot 2021-01-22 at 8.48.53 PM]

hahah yeah, and Jeff will probably do it with 3 columns :rofl::rofl::rofl:

@Darren_Murphy how about 1 column? Hold my :beer: ((Now-DAY(Now)+15)+60) - DAY((Now-DAY(Now)+15)+60) [image]

[image] Jeff_Hager: ((Now-DAY(Now)+15)+60) - DAY((Now-DAY(Now)+15)+60) oh dear… :rofl: :rofl: :rofl: :rofl:

It would be incredible to comment if I hadn’t run out of words :astonished:

Okay, so I’ve been playing around with that, and I can’t for the life of me figure out what’s special about the numbers 15 and 60??

Find the last day of the following month

Ask for Help

Jeff_Hager January 22, 2021, 2:06pm 7

@Darren_Murphy how about 1 column? Hold my

((Now-DAY(Now)+15)+60)
-
DAY((Now-DAY(Now)+15)+60)

Fun with Dates

Show Component Always

How to reduce number of columns?

Topic		Replies	Views
Fun with Dates Project Showcase	156	7121	April 19, 2022
Get the days of the current month Ask for Help	10	159	October 10, 2024
If then else with DATE Ask for Help	28	3350	May 25, 2022
🆕 Date-time Math General data-editor	123	14162	September 27, 2023
Spot on Year/week_number(s) calculations Ask for Help	22	201	July 18, 2024

Find the last day of the following month

Related topics