Fun with Dates

[Darren_Murphy]

[Lucas_Pires]

@Jeff_Hager

• 3 days from now

When you see all the bugs in D/T column and decide to use this trick

Also using # days from now colunn to create D/T Start & End column… that’s awesome! lol

[agung_Taufik]

this is very interesting …!
I have a question …
is there a way to determine the day of the week or 2 weeks …?
Example:
if I want a Monday in the next 2 weeks, what should I do …?

[Jeff_Hager]

Yeah, there’s probably a few ways to do that. Would it always be two weeks from today or two Mondays? For example, today is Sunday. Two Mondays from today would be March 8th, but the next Monday after two full weeks would be March 15th. Just trying to understand a little better, your use case and what you want to achieve.

[Lucas_Pires]

It’s not about Date, but it’s related to Math column and I guess you wizards can help me:

How can I turn a number like $12.561.133.187 into $12,5 billions?

PS: In Glide Editor, not GSheets.

[Robert_Petitto]

Math column in my case was Votes/1000

[Lucas_Pires]

Oh yea!
In my case just did /1000000000 for billions

Thanks Bob!

[Rosewebstudio]

You working out how much you want to earn using glide

[Lucas_Pires]

lmao in a near future maybe

[Lucas_Pires]

@Rosewebstudio

You working out how much you want to earn using glide

maybe how much @Robert_Petitto and @eltintero earn nowadays

[Robert_Petitto]

psh…NOPE.

Maybe @eltintero — he’s much more business savvy than I am.

[Rosewebstudio]

They have the full share of the market with their flashy videos etc (they deserve the success, so do you!)

[Lucas_Pires]

Oh, thank you so much!

[Lucas_Pires]

Asset Market

[Rosewebstudio]

Ohh lovely…fun with figures

[Lucas_Pires]

@Rosewebstudio

fun with figures

sorry lol

[Fanny_Ditomene_Sekwe]

I learned more in a day reading posts on this forum than in 4 (wasted) years in college.
Thanks for the tip. God bless

[ThinhDinh]

@Robert_Petitto

Maybe @eltintero — he’s much more business savvy than I am.

Haha you’re excellent as well man, but Jesus is truly business savvy.

[Jeff_Hager]

Figured out a way to get System/GMT time within Glide.

System/GMT Time - Solved!

This is an extension of the request for System Time, please. There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the user’s local time. But if you don’t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, to…

[Jeff_Hager]

May have to follow the whole thread below, but I wanted to share something I learned today. If you create a template column with a date/time and any indication of a timezone, then create a math column to convert that template to a date, then it will lock that date/time to that timezone, but show the date/time converted as it would be in the user’s local timezone. It has some weird issues sometimes and doesn’t seem to allow for all types of date math, but it could solve a lot of people’s issues with locking a date/time to a specific timezone.

@Jeff_Hager

Wow, I guess I didn’t realize that this would work for other timezones. So essentially, if you append the timezone code, such as PST, PDT, MST, MDT, CST, CDT, EST, EDT, etc. or if you append +0, +5, +8, etc. (not sure about negatives or decimals), or better yet, GMT+5, GMT+8, GMT-5, GMT-8, GMT+12:30, etc. after any date/time, it will lock that date time to that timezone, and what’s displayed to the user will adjust accordingly to the user’s local time. This could be a huge advantage for creating meetings or appointments that cross timezones as every user would see a time according to their local timezone.