Tell that to water.
Oh…I know. I’m from Chicago. 32° isn’t freezing subjectively. Now that I live in Atlanta, anything below 50° is “freezing”. I’m walking around with a light coat and no hat/gloves and everyone else is bundled up in their heaviest parkas like they’re about to venture out on a Siberian expedition.
@Darren_Murphy hate you right now. 
@Robert_Petitto Water is week. Salt brine and antifreeze. Now that’s the good stuff. Hehe, it’s nice when you can appreciate how much worse it could be.
-21.7 celsius for the rest of you.
That was a bit inapprop. my bad.
Crap, I missed it. First thought was National Lampoon’s related?
Don’t mean to interject this hilarious thread (It’s currently -24 celsius/-36 windchill where I’m at. “Warm” is -10 celsius - so 26 is a scorcher @Darren_Murphy haha), but I was just wondering:
Is it possible to tell what day of the week it is…
…AND would it be possible (similar to @Jeff_Hager’s End of NEXT month) be able to calculate the end of each WEEK…using Conditional Visibility…?
Example) IF today=Sunday, THEN “reset”. ELSE = “remain active”.
Thanks in advance!
We have a new winner for toughness bragging rights. 
WEEKDAY(date) in a math column will give you the numeric version of a weekday (1-7), so I believe a 1 would be Sunday. So you want the last day of today’s current week? Are you M,T,W,T,F,S,S based or S,M,T,W,T,F,S? Or do you just want to determine what day a particular date or today is?
Had to! 
Thanks for the reply, Jeff. Much appreciated!
I’d go Monday-Sunday. Pretty much its so that certain content resets every Sunday, allowing thr Admin to update the content, every Monday (morning). So expires Sunday at 12PM.
If you just need the value of the day, I think you will still be looking to check it WEEKDAY returns a 1. If your looking to get the actual date for the end of the week, I think I could come up with something for you pretty quick if you need it.
Yeah I guess I could just make it so that IF Today # = 7 (Sunday), THEN “Reset”. ELSE = “Active”.
EDIT: However, I would want it to expire Sundays AT MIDNIGHT…so…
To get the expiry date…I would assume I would have to write the Current D/T (On Mondays) then just use a Math Column to add 7 to that?
I think weeks are Sunday based, so you would have to check for 1 instead of 7. If you are using Today in the formula, then it will automatically flip over to the next day after midnight and update your If column in real time.
Ok - I’ll get crackin’ then! Thanks!
I’m from a tropical 
country which means anything below 65F/18C is freaking freaking. I don’t care what water says, the feeling is just unbearable.
Now a constant 100F/38C day or night it’s what I call perfect.
Ha! Yeah, I couldn’t do 100F constantly. Around here, temps that high usually include high humidity, so a few minutes outside and I’m drenched in sweat. It’s fine if I’m sitting in the shade with a cold beer though.
@Jeff_Hager humidity is always there for us.
People where I am from say that we live 2 yards from the Sun.
Quick question…do Date/Time Columns get over-written when using Edit: “On Submit” > Set Columns action…?
Or are “On Submit” Actions not working?
The app is reflecting the changes, but the Date/Time Column being updated in the GDE is not…
I’m not sure, I was having some issues the other day when using a math column to set another column using increment or by using set column. I feel like there is still some issues with that. Does it work if you set a text column instead bofba date or number column?
Agree.
It might, but I need this particular column to be Date/Time because I have other components depending on a Date/Time dependency for visibility.
Right, but it might be worth testing just to see if the true issue is with updating date or numeric columns, or if it’s just an issue with set column in general.
Good point! Now the real question is…will the Math Column that adds 1 hour to the current Date/Time column that I’m referencing still work if I convert it into a Text Column where the Date/Time is inputted… 
Here in my area, anything between 22C - 30C is normal, less than 22C then it’s like freezing. I don’t know how you guys survive under 10C but I’m sure I don’t want to try haha.
